i have a problem with a very simple relationship lookup in filemaker 7. i have a client contact database and a billing database. i want the client info placed in the billing database when i enter the clients id number. i established the relationship between the 2 databases based on client id number and setup what info to be taken from client info database and placed in the billing database fields but it just does not work (mac platform). ...maybe i am missing something, i am beginner but something seems weird about it. any help greatly appreciated

Sounds like you have two tables, Contacts and Billings. Contacts should have fields ClientID, lastname, firstname... Billings shoulds have ClientID, charges... Note that Billings should not have lastname, firstname... You can show this information by draggging a field in layout mode, select the relationship of Contacts to Billings by ClientID, and lastname, firstname will be a choice.

Hope this helps you get started...

yes that works!!! thanks so very much. i guess i misunderstood how to do lookups..i set the relationship between the 2 tables/databses and then in the auto entry define fileds dialogue i choose look-up value and then chose the info from the corresponnding field in the related table...thanks for the help.

Glad to help.

CHEERS