Is it a one-to-many

[thingssocomplex]

I have one table (Helpdesk) that contains certain fields, one unique record per row, within this table is a field name 'Notes' I have a second table to store the 'Notes' how do I link these so that Helpdesk record can have multiple notes stored against it? I cannot limit a user to one note.

 

[cope]

I would include a joining table, named 'tblHelpdeskNotes' or something of the sort. In this table would be the helpdesk unique id, and the notes unique id, with both tables being a 'one-to-many' for the joining or 'link' table.

Cope

 

[cope]

this is a 1-many relationship

Correct

'tis all a learning curve!

Cope.