Access relationship issues on import

[robgrech]

Hi

I am new to filemaker. I have a database in Access used to keep a record of sales. I have two tables (actually more but if I solve this I ll be able to do it for others), one for sales (fields include, Id, Inv No, Date, Rep Name, Sale Amt) and one for reps (rep id and rep name). In access the data stored for the rep in the sales table is the id of the rep in the rep table.

I exported the two tables to excel. When importing them, I cannot find a way to show the rep name when it comes to the sales form even though I build a relationship.

Don t know if I was clear, Your help would be appreciated.

[LaRetta]

Hi Robgrech, welcome to FM Forums!

"In access the data stored for the rep in the sales table is the id of the rep in the rep table."

"I cannot find a way to show the rep name when it comes to the sales form even though I build a relationship."

The relationship should be:

Sales::Rep = Reps::RepID

... and they should be of the same data type (number?). If that is established then you can take the Rep Name from the Reps table and place it directly onto your Sales layout. If that does not produce the result you expect, then we will have to explore further.

LaRetta