One to Many relationship not working, please help :( (1 Viewer)

[krissyk775]

I need to create one to many relationships between staff, rates, clients and categories - billing. Every time I try and create them it says "Relationship must be on the same number of fields with the same data types" and I have no idea what this means!!

 

[arnelgp]

StaffID in Staff table is Long Integer, while on Billing it is Short Text.

 

[plog]

You've made that mistake in other places as well:

Billing.ClientID, Billing.RateID, BillingStaffID are text, should be number
Billing.BillingDate is Text, should be date

You need to use the correct data type for your data.
You should make your autonumber fields primary keys. Right click and then click on "Primary Key" in design view of the table.
And only use alphanumeric and underscore characters in table/field names. That means no spaces (e.g. [Postal Code] = [PostalCode])
Lastly, tables with only 1 real data field (autonumbers don't count as real data) shouldn't exist. Your Rates table should go. Instead of storing the RateID value in Billing you just store the actual rate value.

 

[krissyk775]

You've made that mistake in other places as well:

Billing.ClientID, Billing.RateID, BillingStaffID are text, should be number
Billing.BillingDate is Text, should be date

You need to use the correct data type for your data.
You should make your autonumber fields primary keys. Right click and then click on "Primary Key" in design view of the table.
And only use alphanumeric and underscore characters in table/field names. That means no spaces (e.g. [Postal Code] = [PostalCode])
Lastly, tables with only 1 real data field (autonumbers don't count as real data) shouldn't exist. Your Rates table should go. Instead of storing the RateID value in Billing you just store the actual rate value.

Hi!!
thank you so much for the help! I fixed all of these errors but I'm running into a different problem now I have attached the new document and a screenshot of the error I'm receiving

 

[plog]

Ok? The error tells you the issue.

 

[krissyk775]

Ok? The error tells you the issue.

I fixed it but I’m still getting the same error as the first time. I’m brand new to Microsoft Access.

 

[plog]

Define fixed it. What did you do?

I opened the most recent database you posted and the issue was there.

 

[mike60smart]

Hi

I added an Eighth Client to the Client Table and you can now set the relationships between Clients & Billing