Thank you , its beginning to make sense, But I do not understand two things, How are the tables related, If I have to assign a Bid#, and the table location is pre-assigned as well, I can have the Item number be an Autonumber, but not the Bid Number, Then How do I relate the two tables? Each time...