M
millie.patel
Hi,
I am working on a form right now.
I have three tables:
tbl_projects
--projectID
--projectname
--projectdescription
--projectmanager
tbl_products
--productID
--productname
--productshortname
--productcategory
tbl_projectproducts
--projectID
--productID
The form is used to enter a project, it has multiple fields (i.e.
project name, project manager, project description).
Only when the project is entered into the database, can I retrieve the
autonumber (primary key) to use to insert values into the
projectproducts table.
Is there a way to retrieve the value on the same form? so that i can
enter the product info right away, besides going to a new page?
thanks!
I am working on a form right now.
I have three tables:
tbl_projects
--projectID
--projectname
--projectdescription
--projectmanager
tbl_products
--productID
--productname
--productshortname
--productcategory
tbl_projectproducts
--projectID
--productID
The form is used to enter a project, it has multiple fields (i.e.
project name, project manager, project description).
Only when the project is entered into the database, can I retrieve the
autonumber (primary key) to use to insert values into the
projectproducts table.
Is there a way to retrieve the value on the same form? so that i can
enter the product info right away, besides going to a new page?
thanks!