Relationship/Data Base Trouble. Query does not return expected or most often no values

[brianrrrr13]

My database will have one 'master' table that is configured in this way

Assembly Type_ID	Part_ID	Description	Unique Identifier/Code	Attribute 1 Heading_ID	Attribute 1 Value_ID	Attribute 2 Heading_ID	Attribute 2 Value_ID	Attribute 2 Heading_ID	Attribute 3 Value_ID
Number	Number	short text	Short Text	Number	Number	Number	Number	Number	Number
Assembly Type	Assembly Type_ID			Attribute Heading	Attribute Heading ID		Attribute Value	Attribute Value ID
Short Text	autonum			Short Text	autonum		Short Text	autonum

So what the idea is to set up relationships between all of these tables to be able to return actual text values from the codes in the 'master' database. My issues are the following:
ID_ATTRIBUTE and ID_Heading relationships are allowing me to do alias, because when I pull them up into a query it shows 3 relationships to the original table and the made aliases.
The next problem is when I use the query, all I get is a blank table. I suspect it is because the query will not return an empty value, but in this database many 'Null' values are expected.
Anyone have any suggestions???

[Welshgasman]

Well to start with, your table/DB is not normalised.
You must be an Excel user?

Plus you have not even shown us what the query code is?

[brianrrrr13]

Yes you are correct. I do not believe it's a query problem but instead a relationship problem. What do you mean by Normalised? This is the relationship I'm having trouble with. The idea is the same as the initial posting, but I switched around field names as to not be confusing
Here is the SQL code:
SELECT CALL_DRAWINGS.DRAWING, ID_PumpType.PumpType, [ID_DIN-FIND].[DIN-FIND], ID_ATT_VALUE.ATT_VALUE, ID_ATT_VALUE_1.ATT_VALUE
FROM ID_PumpType INNER JOIN (ID_ATT_VALUE AS ID_ATT_VALUE_1 INNER JOIN (ID_ATT_VALUE INNER JOIN ([ID_DIN-FIND] INNER JOIN (ID_PumpSize INNER JOIN CALL_DRAWINGS ON ID_PumpSize.ID = CALL_DRAWINGS.[PUMP SIZE]) ON [ID_DIN-FIND].ID = CALL_DRAWINGS.[DIN-FIND]) ON ID_ATT_VALUE.ID = CALL_DRAWINGS.[ATT1 VALUE]) ON ID_ATT_VALUE_1.ID = CALL_DRAWINGS.[ATT2 VALUE]) ON (ID_PumpType.ID = ID_PumpSize.PT_ID) AND (ID_PumpType.ID = [ID_DIN-FIND].PT_ID);

[pbaldy]

Post 3 was moderated. FYI, attachments need to be attached via the "Go Advanced" screen:

https://www.accessforums.net/showthread.php?t=70301

[pbaldy]

Post 3 was re-moderated again due to an invalid attachment. I'm posting to trigger email notifications.

[CJ_London]

What do you mean by Normalised?

https://www.databasestar.com/database-normalization/

some example data and what outcome you expect from that example data will also help us to help you

[madpiet]

My database will have one 'master' table that is configured in this way

Assembly Type_ID	Part_ID	Description	Unique Identifier/Code	Attribute 1 Heading_ID	Attribute 1 Value_ID	Attribute 2 Heading_ID	Attribute 2 Value_ID	Attribute 2 Heading_ID	Attribute 3 Value_ID
Number	Number	short text	Short Text	Number	Number	Number	Number	Number	Number
Assembly Type	Assembly Type_ID			Attribute Heading	Attribute Heading ID		Attribute Value	Attribute Value ID
Short Text	autonum			Short Text	autonum		Short Text	autonum

So what the idea is to set up relationships between all of these tables to be able to return actual text values from the codes in the 'master' database. My issues are the following:
ID_ATTRIBUTE and ID_Heading relationships are allowing me to do alias, because when I pull them up into a query it shows 3 relationships to the original table and the made aliases.
The next problem is when I use the query, all I get is a blank table. I suspect it is because the query will not return an empty value, but in this database many 'Null' values are expected.
Anyone have any suggestions???

Oh yikes. It's a crosstab query. I'd do it in Excel (that's what I always say these days.) Open Excel, Get Data, from (whatever source type it is). Convert the Attribute columns to TEXT. Then Merge the pairs with a delimiter in the middle, like "|"). So if you end up with ONE column for each (Heading | Value) pair. Then you unpivot that mess. Then you split it by "|", and finally convert back to numbers. Then import.

If you can, post a dummy without any confidential column values and I'll see if I can do it.

[mike60smart]

Hi
Best to upload a zipped copy of your database.