I have two tables, A & B with no relation. How can i make a field from table A to auto lookup a global field from B whenever i make changes?

Any solution beside using script? Thanks

There's way to little to go here, what is the purpose... since putting a global field on your layout from another table, actually exhibit this behaviour ...since relations here are irrelevant unless you attempt recieving stuff into a global??

It's however a questional approach, therefore you have to justify why it has to be global field?

--sd

Hi John,

[color:orange]Søren is right, there is too little information for us to do much with.

Also, Please put your Skill Level in your Profile so that we can get an idea as to how much detail you will need when we respond.

Lee

Alright, thanks sd and lee for the reply, i will elaborate more. Btw, i can't seem to find the skill level setting in profile... wierd. Just fyi, i started using FM only 2-3 mths back on a almost daily basis. So probably beginner - novice?

Basically in table A, i will be putting in destinations and restaurants with rates to calculate the total cost based on the no. of people. Thus table B will contains the gfield (rates) to be used in A.

I can use TableB::(rates) in table A but i do need to keep records of the rates saved and not simply change whenever there is changes in B.

Location 1, 2 and 3 are fixed thus i only need the total from table B. (Restaurant) will be a dropdown field from table B.

Table A

(Location 1) B::(Total 1)

(Location 2) B::(Total 2)

(Location 3) B::(Total 3)

B::(Restaurant) (Pax) B::(Rate) (Total)

B::(Restaurant) (Pax) B::(Rate) (Total)

.

.

(GrandTotal)

I hope i am not confusing anyone :

Edited January 16, 200719 yr by Guest
Unable to find skill level settings

Sounds like you may have a relationship if I understand correctly.

let me see...

each record contains something like...

Table A is Restaurant

Number_Of_Guests

CostTotal = (Rates::Rate_Per_Guest * Number_of_Guests)

LocationName

Address

RestaurantID_c ~ this one has a dropdown value list that inserts the restaurantID_p as well as shows the name of the restaurant.

Table B is Rates

RestaurantID_p (autoEnter Serial Number)

Rate_per_Guest

Yep that is the case, except table B is simply using Restaurant as the ID. This will be a example of my layout for table B. Its list view btw.

Header

Location A (Rates_A)

Location B (Rates_:

Location C (Rates_C)

--------------------------------------------------

Body

(Restaurant) (Rates)

The location's rates will be the same in both tables, while the restaurant and it's rates can be added in the table B.

The (rates) field in table A is different because i want to be able to keep a record incase the rates changes.

Btw, i can't seem to find the skill level setting in profile... wierd.

You can go to My Profile --> FileMaker Questions.

Here is the shortcut.

http://fmforums.com/forum/usercp_fmf.php?