Button to create a new table?

[vidus]

That's why I asked, because it should NOT be that way. "Everyone" needs to learn how to use a database and we're attempting to help you out here. Keeping quotes and active jobs separated is NOT an appropriate way to handle this. As ghudson mentioned, you mark them active or not. You do not give users access to the tables so they should never need worry about what goes on under the covers. You can provide them QUERIES with Forms to give them what they need.

Does that make sense?

So, anyway, I was asking as I'm looking trying to understand what we need to keep and what we don't. Job Description would be what I would use and will use in my example, if they are the same thing.

I completely understand what your saying. I am going to redesign the database in the long run because I want to run it on sql instead anyways. So I am going to keep these two table merged into one and use queries to seperate.

Though I am still left with how to track jobs individually. You see, if every job has 20 purchase orders, I need to track that in a new table with columns and rows... so not sure what to do here.

 

[vidus]

So next question -

You have Shipping Colour in the Job Board table. What does that mean?

(so still analyzing)

everything gets tagged with a color band to identify what shipper picked up what.

 

[boblarson]

I completely understand what your saying. I am going to redesign the database in the long run because I want to run it on sql instead anyways. So I am going to keep these two table merged into one and use queries to seperate.

Though I am still left with how to track jobs individually. You see, if every job has 20 purchase orders, I need to track that in a new table with columns and rows... so not sure what to do here.

Well, not really two tables into one. So far I have 4 tables from one of the two. Purchase orders - okay, so how do they apply to the jobs then? Are these actual products that are being produced?

 

[vidus]

Well, not really two tables into one. So far I have 4 tables from one of the two. Purchase orders - okay, so how do they apply to the jobs then? Are these actual products that are being produced?

thats right. we get materials from purchase orders and need to track different documents that come with the PO's... like certificates, grade, size etc.

at the moment, we have no system in place to track these documents so everyone is running around like chickens trying to find a single piece of paper.