Hey everyone.

I have a program that will load project data according to the project number selected. One of the fields associated with the project number is the project manager. I have another table called Contact which is the contact information for the project mangers. I have a link setup that will show the Contact form, but how do I let the Contact form know which project manger's contact info to show?

Sorry if this isn't a good explanation of the problem.

10 Years
Discussion Span
Last Post by iamthwee

Not sure how to do that.

Is there a way to assign a value to a database during run time? Like could I do something that says If ProjectManager == Dan Then ContactID = 1 (ID is the key for the 2nd table)


Why on earth would you want to do that?

You should already have a basic schema for your database? Are the tables in your database normalised? Do you even know what you are doing?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.