Ask Your Question

How to have a subtable in a table in base?

asked 2016-01-18 17:56:33 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-03-13 19:39:07 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-18 17:56:33 +0200

Seen: 466 times

Last updated: Mar 13 '16