I am trying to get a record into a form and the form is based on the query using two tables. When I tried to add a record I get a message saying that the join type is missing in the second table. My question is this: is there a way to add a record to a query using two tables? I am assuming the join type they are referring to would be the fields that relate the two table - in this case it would be the ID fields. So it seems like the problem would be to get the ID in the first table into the ID field in the second table. How can I do this or is it even possible?
Mike