Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have been struggling with this for a bit and I am running out of ideas.
I have a need to link 2 tables together by Part Number. I also need a master calendar for these tables. How can I link them without creating a circular reference? picture of the data model is here.
Any direction would be appreciated.
thanks
-L
Hi,
table Complaints: ID AS IDComplaints
Send me a sample of your data
Here you go.
I need 2 link tables, Im just not sure how to do that without getting the circular reference
Hi Leo,
The ID in your linktable, is it date ID or just unique key for your link table?, if there's no logical link between IDs between linktable and your complaints table, just liase one as Fer suggest.
Hi,
TimeLinkTable:
load date(floor(Time)) as Date,
_Type,
ComplaintID AS _ComplaintID,
ShipID,
Time