topic Re: link multiple columns to one table in App Development

link multiple columns to one table

QuentinZNA — Sat, 21 Aug 2021 21:14:07 GMT

Hi everyone, i have a pressing issue I can't find the solution for.

I have two tables;

Table Labstaffing;

- LabstaffingID

- Fullname

Table Sample;

- SampleID

- RequestingLabstaffingID

- RegisteredbyLabstaffingID

- CutbyLabstaffID

I want to link the variations of labstaffingID from table "Sample" (requesting, registered & cut) to the LabstaffingID from

the table "Labstaffing". This way I can fill in the "fullname" for these ID's, so I know who performed these actions.

Anyone know how to do this?

Re: link multiple columns to one table

Saravanan_Desingh — Sat, 21 Aug 2021 21:33:30 GMT

Please try something like this

Sample_Output: NoConcatenate LOAD SampleID, RequestingLabstaffingID, RegisteredbyLabstaffingID, CutbyLabstaffID Resident Sample; Left Join(Sample) LOAD LabstaffingID As RequestingLabstaffingID, Fullname Resident Labstaffing;

Re: link multiple columns to one table

rwunderlich — Sat, 21 Aug 2021 22:16:55 GMT

You will want to move the *staffingId values from the Sample table into a link table. That will give you the Many-to-one relationship between Sample and LabStaffing.

LinkTable:
LOAD SampleID, RequestingLabstaffingID, RequestingLabstaffingID as LabstaffingID Resident Sample;
LOAD SampleID, RegisteredbyLabstaffingID, RegisteredbyLabstaffingID as LabstaffingID Resident Sample;
LOAD SampleID, CutbyLabstaffID, CutbyLabstaffID as LabstaffingID Resident Sample;

Drop Fields RequestingLabstaffingID, RegisteredbyLabstaffingID, CutbyLabstaffID From Sample;

-Rob