Only Related Values List

[DMGoldie]

Hi,

This one is driving me nuts.

I have a Job table, a Company table and a Contact table.

In the Job table each record is a Job - represented by Job Number.

In the Company table each record is a Company - represented by a Company Number.

The Contact table is only used as a portal. When entering a Company you can also enter Contact names via a portal.

Company ABC has John Smith and Ben Gold as contacts.

Company XYZ has Jim Jones and Betty Downs as contacts.

I create a Job in the Jobs table - Job Number 1001.

I have 4 fields on the layout:

Job Number - Auto Entered

Customer Number - Drop Down List

Company Name - Fills in after Customer Number is picked.

Contact - I want this to be a Drop Down List using the "Only Related Values" function but I cannot get it to work.

Any ideas? I can post the file if needed...

Thanks!

dmg

[Merit Solutions]

Feel free to email me the file - i assume you have valid relationships already established?

Jon

[email protected]

[Lee Smith]

Files can be attached to posts here, for information on how to do this, please see the [color:blue]Help.

One of the benefit of being a member of the Forum, is that you can see different ways to achieve different solutions to the same problem. By keeping the help on the Forum, anyone with a similar problem can reap the benefit of the help provided.

Lee