R
RMP
I am new to access and databases, but I have some academic coding experience.
If this is the incorrect forum in which to pose this question, I apologize.
I have two questions. First, how do I setup a form to lookup the
corresponding records of a particular computer and invoice (based on
SerialNumber or InvoiceNumber)
Second, how do I setup a form for adding new computers/invoices so that I
can do it all on one form. For example, I order a new computer, get it in,
and begin keying in the information. When I enter information into the form,
it creates a new computer record, a new (or uses an existing invoice if the
invoice number is found) and then creates a linking entry in the junction
table.
I am working with three tables:
Computers:
ComputerID (replication ID, auto number)
SerialNumber
Name
etc
Invoices:
InvoiceID (replication ID, auto number)
InvoiceNumber
PurchaseDate
etc
ComputerInvoice:
ComputerInvoiceID(replication id, auto number)
ComputerID
InvoiceID
I currently have the relationships in Access setup in the following manner:
Computers.ComputerID 1 -> many ComputerInvoice.ComputerID (enforced ref
integrity)
Inovices.InvoiceID 1 -> many ComputerInvoice.InvoiceID (enforced ref
integrity)
Any help or suggestions would be greatly appreciated.
If this is the incorrect forum in which to pose this question, I apologize.
I have two questions. First, how do I setup a form to lookup the
corresponding records of a particular computer and invoice (based on
SerialNumber or InvoiceNumber)
Second, how do I setup a form for adding new computers/invoices so that I
can do it all on one form. For example, I order a new computer, get it in,
and begin keying in the information. When I enter information into the form,
it creates a new computer record, a new (or uses an existing invoice if the
invoice number is found) and then creates a linking entry in the junction
table.
I am working with three tables:
Computers:
ComputerID (replication ID, auto number)
SerialNumber
Name
etc
Invoices:
InvoiceID (replication ID, auto number)
InvoiceNumber
PurchaseDate
etc
ComputerInvoice:
ComputerInvoiceID(replication id, auto number)
ComputerID
InvoiceID
I currently have the relationships in Access setup in the following manner:
Computers.ComputerID 1 -> many ComputerInvoice.ComputerID (enforced ref
integrity)
Inovices.InvoiceID 1 -> many ComputerInvoice.InvoiceID (enforced ref
integrity)
Any help or suggestions would be greatly appreciated.