Search results

The relationship is more one-to-one each transaction has a control number, that number has certain info attached and required that certain information be verified by the use (data entry form) I cant write to the table that holds the info as it is connected to an outside source. Do you know and...

Thanks MarkK, one table contains data from a data warehouse, the other table is the one which the form rights to and calls the fields that need to be entered. the query brings these two tables together and gives me the "id" field which calls a bunch of data from form one and allow data entry...

I created an input form based off of a query that prefills some data using the tab stop, I have a primary key set on one of the tables in my query (if I make a primary key on both tables it prevents my tab stop from working. The thing is I need to prevent duplicate entry on the input form but I...