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.
Erm have to written the correct SQL expression then?
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?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.