Newbie question

[arbrctb]

Hi guys,

Have a really basic question here, I'm just starting out with FileMaker and I would really appreciate a little advice?

I have a form in which I'd like to choose a client name from a list, drawn from a value list which is taken from another table (a client contact list).

I then want another field beneath that which looks up that client's reference number from the referenced table (the client contact list).

I managed to achieve this earlier but somehow broke it - could anyone give me some pointers here as to what I should do to get this functioning?

It's the lookup function that's broken - I can select the client's name in the first field with no issue, but the second field will not extract the client ID no matter how hard I try.

Any help would be appreciated...

Adrian

[myopus]

Hi,

I try to understand english and I'll try to be understandable.

Your ID contact must come directly from your value list.

You must tick the option "Also display values from the second field" and "Show value only from the second field"

The first item of the value list must be the ID, and the second the contact's name.

Hope it(s help

Gilles

[arbrctb]

Hi,

don't worry your English is fine!

Thank you for the tip. While this could be a workaround, I need to be able to:

Select my client's name in one field, based on the values in another table;

and in the second field, I want the unique ID number that's assigned to their record in the other table to automatically appear.

Any idea how this is done?

Your help is appreciated

Adrian

[arbrctb]

Hi

I've just fixed this problem, it was to do with the relationships. I'm still not quite sure how relationships between fields work but I had a play around and it's now working as I intended.

Thank you :D

[myopus]

Hi Adrian,

be carefull about that

if you have put your relationship on the contact's name, so, effectivly,you can get his ID in the second field. But it is not a good solution, because if your database host two or more similar name, the ID collected will be wrong

Gilles