tell me all the correct relationship so that I know what should I do

Please be more specific. See Rule #2.

Customer Pricing

the customerprice #error

Make the customerprice table a lookup table then this will go

Evil Access Stuff: Lookup Wizard

I have a better application after I know the techelp videos .....images videos for instance,I can put the jpg files in my form and report
Thanks alot

For customer pricing videos I still get the #error

Tables using autonumber datatypes
I create the ENFORCE REFERENT INTERGRITY relationship
IT WORKS VERY WELL
But

As I change the datatypes to SHORT TEXT
The same relationship as above,I get the #error

How come

Don't use short text to make relationships. Use IDs (long int).

I have been using in in all my tables with short text,to make easy find records

What should I do

It's okay to have short text fields. And if you want to have your own product codes, for example, that are text-based, that's okay, but you should always form your relationships with IDs and Autonumbers, which are long integers.

Replace Natural Key

I am sorry I just had a hi blood pressure 184/100,so that I have to have a rest for a while
I will be back later soon