Relationships ID's and fields...

**arrudac30** · 08-14-2015, 05:28 PM

Hi all.

I have setup two tables.

Table 1 = customerT
Table 2 = countyT

Table 1 = customerT = Fields are =

ID (PK) auto generate number
FirstName
LastName
Address 1
Address 2
PostalCode
County
Country

Table 2 = county = Fields are =

ID (PK) auto generate number
County

Relationships created are Table 2 = ID (1 to many) to Table 1 = County

The issue I'm having is that I can't enter in the customer table county field, the word "Norfolk" which is the description of the county for record 1. It seems I must enter 1 and not Norfolk. This is not good as one would thought Norfolk is the county, not 1.

But again, I can't make the relationship between Table 2 = County to Table 1 = County.

How would one go past this? I mean, anyone reading county 1 means nothing.

Kind regards,
Albert

**June7** · 08-14-2015, 05:37 PM

Options:

1. set County field in CustomerT as a number type and save the ID from CountyT as foreign key

2. remove ID from CountyT and save the County text value into County field of CustomerT

**arrudac30** · 08-14-2015, 06:11 PM

Thanks June7.

Learning very slowly.

I have created no a drop-down list for Title and County. This has created a relationship but different than the one before (1 to many).

Now, if I type something else that is not in the countyT and titleT, it will still accept with no error.

Many thanks for helping.

Kind regards,
Albert