B
BrookieOU
I have a form where users enter billing information. This includes PO#,
Invoice#, Amt, so on and so forth. This is based on a query that pulls
fields from the following tables:
Project Table: ProjectID, PO#, Project Name
Billing Table: BillingID, Invoice#, Amt
Employee Table: EmployeeID, Employee Name
What I'm trying to do on the form is have a person type in the PO# and it
will automatically fill-in the box containing the project name. Any ideas on
how to do this? I've done it before in a really backwards way and wanted to
do it right this time.
Thanks!
Invoice#, Amt, so on and so forth. This is based on a query that pulls
fields from the following tables:
Project Table: ProjectID, PO#, Project Name
Billing Table: BillingID, Invoice#, Amt
Employee Table: EmployeeID, Employee Name
What I'm trying to do on the form is have a person type in the PO# and it
will automatically fill-in the box containing the project name. Any ideas on
how to do this? I've done it before in a really backwards way and wanted to
do it right this time.
Thanks!