I'm trying to create an electronic database for my business, and I'm wondering what would be the best way to approach this. I would like to have a basic table (possibly in Access) which contains customers in each row, and columns containing the cost of the job for that customer, and gross profit. However, I would like to create a link where i can click each customer and be provided with details on the specific job (for example, what materials were used, number of work hours put into the job, and the corresponding numbers and how they add up). I'm wondering if I could create a link to a new table (within access, so that I don't have to make a million tables in excel) for each customer job. Any suggestions???
- Jordan
- Jordan