DB problem from someone new to db

[m_a4]

Hi,
I have a problem with a db.

i has particular tables:

GOOD
GUpc (PK)- unique product code
GDescription

PERSON
PReference (PK)
PName
PSurname
PTel
PMail

COMPANY
CReference (PK)
CName
CAddress
CTown
CPostcode
CCountry

RGA
RGAReference (PK)
CReference (FK)
PReference(FK)
GUpc(FK)
RGADate
RGASatus
RGACostOfRepair

I managed to get a query working so that i can search the PERSON table searched by surname

PARAMETERS [PSurname] Text ( 255 );
SELECT PERSON.PReference, PERSON.PName, PERSON.PSurname, PERSON.PTel, PERSON.PMail
FROM PERSON
WHERE (((PERSON.PSurname)=[PSurname]));

but i cant get it to work i wanted to search it by PReference

PARAMETERS [PReference] Text ( 255 );
SELECT PERSON.[PReference], PERSON.[PName], PERSON.[PSurname], PERSON.[PTel], PERSON.[PMail]
FROM PERSON INNER JOIN RGA ON PERSON.PReference=RGA.PReference
WHERE (((PERSON.PReference)=[PReference]));

I get a msg that The expression is typed incorectly or is to complex to be evaluated. For example a numeric expression my contain too many complecated elements. Try symplyfing the expression by assigning parts if the expression as variables.

AND THIS IS NO HELP FOR ME... francly

The same situation is with all the other tables- its possible (query- search) for everything apart for the primary keys.

I prepared a querry gathering data from all those tables. I managed to get it work with parameter like the one below with surname

PARAMETERS [PSurname] Text ( 255 );
SELECT COMPANY.*, RGA.*, PERSON.PName, PERSON.PSurname, COMPANY.CName, GOOD.GDescription
FROM PERSON INNER JOIN (GOOD INNER JOIN (COMPANY INNER JOIN RGA ON COMPANY.CReference = RGA.CReference) ON GOOD.GUpc = RGA.GUpc) ON PERSON.PReference = RGA.PReference
WHERE (((PERSON.PSurname)=[PSurname]));

but the same situation again, i cant get it to work if i want to get it for RGAReference, CReference, PReference,GUpc

I don't know what i am doing wrong?
have I designed it all wrong or is it just a small thing...

Thank you for all your help







My problems started when I tried to run a querry that will return the GDescription (this tables store data about 3000 products)

 

[jzwp22]

You specify the parameter as text, but I assume that since the Preference is a key field that it is probably a long integer. So you need to change the parameter to a long number

PARAMETERS [PReference] long;
SELECT PERSON.[PReference], PERSON.[PName], PERSON.[PSurname], PERSON.[PTel], PERSON.[PMail]
FROM PERSON INNER JOIN RGA ON PERSON.PReference=RGA.PReference
WHERE (((PERSON.PReference)=[PReference]));