advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Need FileMaker Pro (9) Help/Guidance please
Posted by: MrNoBody
Date: April 07, 2013 06:37PM
Running FMP9 OSX (which creates fp7 files compatible with 8.5 on an XP machine).
Need to know if it is possible for one Table{1} within a Database to create and update records in another Table{2}. If so, how to accomplish? Or, would it be necessary to populate Table{2} and just use it for Look-Ups in Table{1}?
Any links would be greatly appreciated too.
TABLE 1
Fields:
entry_date
vend
item_no
desc
quan
ship_date
date_recd
TABLE 2
Fields:
vend
item_no
desc
"vend", "item_no", & "desc" are TEXT.

t-i-a for any help thumbsup smiley



39°36'17"N 75°44'43"W

DuckDuckGo
The search engine that doesn't track you.

DemComm Records 2021 Greatest Hits
includes:
Taxman by Joe & Nancy's Rich Ice Cream Band
The Humpty Dance by The Harris-Brown Hookup
Lets Spend The Night Together by The Fang-Swalwell Gang
Díaz-Canel Is A Friend of Ours by The AOC Squad
My Old Kentucky Retirement Home by MitchMcC & The Soggy Boxer Boys
Burning Down The House by Merrick & The Goons
Back In the USSR by Bernie's Red Square Trio

patriot smiley
Options:  Reply • Quote
Re: Need FileMaker Pro (9) Help/Guidance please
Posted by: rob banzai
Date: April 07, 2013 09:47PM
What is it you're trying to do? If you have an item that is represented in two tables and you want data entered in one to show up in the related record in another table, then you need to form a relationship between them.

The key is for the record to have a unique identifier to base the relationship on. An example would be a customer number, or an item serial number. That becomes the related field.

In Table #1 you enter the info, let's say it's "color" and then in Table #2 after the relationship has been formed on the record layout you can add the related "color" field from Table #1. By default the layout editor will offer you fields from Table #2 but you should be able to switch the field selector to show fields from Table #1.

Once that's done when you look at a record in Table #2 if the related record has content in the "color" field it will be displayed from the record in Table #1.



I'll see you again... when we are both like golden clouds on the wind.
Options:  Reply • Quote
Re: Need FileMaker Pro (9) Help/Guidance please
Posted by: MrNoBody
Date: April 10, 2013 05:56AM
thanks rob. My google-fu got better & I found the solution.



39°36'17"N 75°44'43"W

DuckDuckGo
The search engine that doesn't track you.

DemComm Records 2021 Greatest Hits
includes:
Taxman by Joe & Nancy's Rich Ice Cream Band
The Humpty Dance by The Harris-Brown Hookup
Lets Spend The Night Together by The Fang-Swalwell Gang
Díaz-Canel Is A Friend of Ours by The AOC Squad
My Old Kentucky Retirement Home by MitchMcC & The Soggy Boxer Boys
Burning Down The House by Merrick & The Goons
Back In the USSR by Bernie's Red Square Trio

patriot smiley
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 270
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 5122 on October 03, 2020