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.
Jump to PostErm have to written the correct SQL expression then?
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.