I am sure this is quite simple. I want to type in a client ID from my client table into my sales form which would then enter the clients Name, etc. I have established relationships between the two tables and have layed out fields matching the two tables. When I use find mode in Sales and enter a client ID I get this error: No records match this set of find reguests. After many hours of reading thru th ehelp files I am still at a lose. This should be the easiest thing to do??

Spiritbear:

Welcome to the Forums.

You've got the work done, but the method wrong - you shouldn't be in Find Mode, but Browse Mode. In your layout, where you want the client's name, etc., to appear, make sure they're related fields via your relationship. In Browse Mode, if you enter the client's ID number, the related data should show up automatically.

-Stanley

Thanks for your reply. When in Browse mode I call for a new record but I can not enter the client ID field which is linked to client list: client ID???

Spiritbear:

You should be entering the Client ID in the field that is related to client list::client ID. So, you'll have a field that is local to your Sales form, where you enter the client ID; that, in turn, relates to the Client table and pulls the data from the record with the same ID number in it.

-Stanley

Ok. I changed the field Client ID on the sales form to the "local" client ID on the sales form and voila the client info from my client list popluated my sales form!!! I told you it was something very simple....

Thanks alot.

Spiritbear:

Not a problem. We're here to help.

-Stanley