Autofill Form-Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, here's the problem...

I need to connect an autofill form that stores the Agency information, to
sub form that stores the invoice information for a travel agency. There is no
common field between the two. one form source is the tblAgencies and the
other is the tblInvoiceDetails.

I guess I should give the tblAgencies a UniqueID, the tables existed and
were populated when I started the project...

I know how to create an AutoFill/AutoLookup form but I know that requires a
one to many relationship with the tblAgencies having a Primary Key as the one
and the same data field as the many in the tblInvoiceDetails table to place
in the grid.
 
If you're trying to get a uniqueID field for the agencies table you could open the agencies table in
design view. Select File/Save As from the main menu. You should be prompted to add a Primary Key.
If so select yes. If not prompted go ahead and add the field AgencyID set it as the primary key
with a data type of autonumber. Close and save the table. Now design an append query using the
original agency table as the data source. Add all the fields to the grid and run the query to
append this data to your new Agency table. Now you have all your data with unique ID field.

Hope this helps!
 
Back
Top