M
Misha
Hello All,
I am extremely new to access. I have set up two tables that I need with the
information in them and I set up a relationship that allows me to link
invoices with the corresponding contract/vendor number. What I have been
trying to do is have a combo box show all possible contract/vendor numbers
for the user to choose and then enter in all the information about invoice
that corresponds to that contract. However, in the way I set it up the combo
box does not show the list of all contracts in the database and requires the
user to type it in and then correctly saves it in the proper place; when I
modify the combo box to show the information it will not save the invoice
data into the location that i need which it did prior to me modifying the
combobox. Then if i change the combobox so that it saves the data into the
appropriate field I get the error "You cannot add or change a record becausea
related record is required in table "frmContract"
Schematic:
tblContracts: Contract #, Contract ID, Vendor Name
tblInvoices:Invoice ID,Invoice Amount, contract #
Any suggestions would be greately appreciated
I am extremely new to access. I have set up two tables that I need with the
information in them and I set up a relationship that allows me to link
invoices with the corresponding contract/vendor number. What I have been
trying to do is have a combo box show all possible contract/vendor numbers
for the user to choose and then enter in all the information about invoice
that corresponds to that contract. However, in the way I set it up the combo
box does not show the list of all contracts in the database and requires the
user to type it in and then correctly saves it in the proper place; when I
modify the combo box to show the information it will not save the invoice
data into the location that i need which it did prior to me modifying the
combobox. Then if i change the combobox so that it saves the data into the
appropriate field I get the error "You cannot add or change a record becausea
related record is required in table "frmContract"
Schematic:
tblContracts: Contract #, Contract ID, Vendor Name
tblInvoices:Invoice ID,Invoice Amount, contract #
Any suggestions would be greately appreciated