Data Model help

[leocattqv]

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

[el_aprendiz111]

Hi,

table Complaints: ID AS IDComplaints

Send me a sample of your data

[leocattqv]

Here you go.

I need 2 link tables, Im just not sure how to do that without getting the circular reference

[#4]

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.

[el_aprendiz111]

Hi,

TimeLinkTable:

load date(floor(Time)) as Date,

_Type,

ComplaintID AS _ComplaintID,

ShipID,

Time