Importing Key Fields

[Mark L]

I have an application that has a Products table and a Manufacturer's table.

I have the Product table's ManfID linked to the ManfID on the Manufacturer's table.

In the Product layout, there is a drop down list, based on the Manufacturer's table that allows the user to select the Product's manufacturer ID. There is a second field, a related field from the Manufacturer's table that displays the actual manufacturer's name.

The Manufacturer's tables currently only has two records that look like this:

ManfID: 1 (formatted as Text)

ManfName: Company A

ManfID: 2

ManfName: Company B

I'm having a little trouble importing an Excel spreadsheet for the Product data, such that the Manufacturer's ID number causes the relationship to automatically form - and see the name on the layout. In other words, I get all my all Product data in, including the field Product_ManfID - but the related field in the layout doesn't automatically read "Company A" . I can do it "manually" by clicking on my drop down box and making the selection - but I have 200+ Products and would like to avoid this.

Two things I've tried:

1) Confirmed that I opted for "Perform auto-enter when importing..."

1) I converted the .xls file to an FMP database, and converted the file type for ManfID to Text - then did the import, and still had the problem.

There must be a way around this - any suggestions?

Thanks,

Mark

[Mark L]

OK - I apologize, this is my second "Doh!" posting today - and hopefully my last for a good long time.

I was importing the ManfID into the wrong key field.

Again, my apologies for wasting space.

-Mark