AnsweredAssumed Answered

relationships and dropdown

Question asked by patfee on Aug 30, 2011
Latest reply on Aug 31, 2011 by philmodjunk

Title

relationships and dropdown

Post

Hi,

i'm trying to create the following:

Client Table, with a PK & Name
Client Contact Table, with a PK, a FK Client and a Name
Project Table, with a PK, a FK Client, a FK Client Contact

so far so good

in the Project Form i want to select a client using a dropdown box

In the Project Form i want to select a client contact using a dropdown box that is only showing the contacts related to that client

i cant seem to manage this

could someone maybe issue an example file? or direct me to a tutorial?

many thanks

PAtrick 

Outcomes