I have a form with the following SQL statement:
SELECT Orders.CustomerID, Customer.FirstName, Customer.LastName,
Customer.Address, Customer.City, Customer.State, Customer.ZipCode,
Customer.Phone, Customer.Fax, Orders.OrderID, Orders.CustomerID AS
Orders_CustomerID, Orders.TodaysDate, Orders.StartDate, Orders.EndDate,
Orders.ArriveTime, Orders.StartTime, Orders.EndTime, Orders.Notes,
Customer.CustomerNumber, Orders.CustomerID, Customer.CustomerID,
Customer.Email
FROM (Customer INNER JOIN Orders ON Customer.CustomerID = Orders.CustomerID)
INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID;
I am trying to add an unbound combo box to the form above. I created a new
table, 'tblConfRooms'. This table contains the names of conference rooms. I
related the new table's primary key, RoomID with the table 'Orders' by adding
RoomID to it and creating an Enforced relationship. When I add the combo box
and try to add an order, I get the following error message: Error #3201
You cannot add or change a record because a related record is required in
'tblConfRooms'. I hope there is enough information here for someone to help
me with this.
Thanks