Populating fields from another form

[gmmccarthy]

I deal with freight carriers and each one is assigned a code. There are over 30,000 carriers so I don't want them all in my carriers table.

I have them all in a CarrierCodes table. I would like to open a form that would allow the user to search for the appropriate carrier and when they choose it would populate that data to my Carriers table.

Any help and suggestions will be appreciated.

Thanks.

Gary

 

[ShaneMan]

Hey Gary,

I guess one suggestion I would have it that you could add a field in your Carriers Table that would hold either the primary key or CarrierCode from the CarriersCode table. On the separate form, that allows the user to search the CarriersCode, allow the user to see the appropiate information (from CarriersCode table) and after they have made their selection, then add the primary key number or CarrierCode to the Carriers table. The two tables could (should) have a relationship built off of this added field.

Hope that at least sparks some idea's for ya,
Shane

 

[gmmccarthy]

Thanks Shane,

I'll give it a try.

Gary