Hi All,
I have a data entry form where i add information about a supplier. Due to space restrictions, i need to add a command button to the form which will open a pop up form where i can add notes about that supplier. I have two tables like below
tbl_Suppliers
SupplierID Autonumber PK
SupplierName ShortText
PhoneNo Number
Address LongText
tblNotes
NotesID AutoNumber PK
SupplierID Number FK
Comments LongText
I've created a relationship between the two tables but i get a message when i click the command button telling me a related record is required in tbl_Suppliers ?
I'm confused
I have a data entry form where i add information about a supplier. Due to space restrictions, i need to add a command button to the form which will open a pop up form where i can add notes about that supplier. I have two tables like below
tbl_Suppliers
SupplierID Autonumber PK
SupplierName ShortText
PhoneNo Number
Address LongText
tblNotes
NotesID AutoNumber PK
SupplierID Number FK
Comments LongText
I've created a relationship between the two tables but i get a message when i click the command button telling me a related record is required in tbl_Suppliers ?
I'm confused