I have a small business database, I have a work table in which I put each job as a separate entry, I also have a invoice table where I want to put multiple work entries via the workID, I am unable to figure put how put put multiple ids from one table into another table if you get what I mean.
Thanks
In the Invoice table you can bill multiple jobs but the job table can only be billed on one invoice. This is a one-to-many relation. You need nothing in the Invoice table pertaining to the job table. In the job table you should have a field for the invoice number. Now many jobs can have the same invoice number.