Hello,

I am using InfoPath 2003. I connected the form to a SQL database that I
created. As of right now, I only have 2 tables in it. In the rimary table the
columns are as follows: Location ID (Primary Key, indexed), Location, City,
and State. The second table has Transaction ID(Primary Key, indexed),
Location ID, Date, and Time.

The Primary table has been created. I do NOT want to add any more records to
it. However, when I submit records via InfoPath, the Location is re-entered
and a new Location ID is created.

How can I prevent this from happening? I want the Location ID to
automatically appear when I enter a Location that I know is in the database.

Any help is GREATLY appreciated!