Auto Filling an order checkbox based on whether order details have been ticked. (1 Viewer)

C

Chill

New member

Local time

Tomorrow, 01:19

Joined

Apr 21, 2015

Messages

3

• Aug 13, 2015

• #1

Greetings!

I've come up against a wall in the process of designing a new database,
I have a table of jobs (Job list), and a table (Job Details) that lists individual products for each Job.
Each entry in Job details has a box to be checked when completed.

I'm trying to autofill a checkbox in table 'Job list' based on whether the relevant Job products have been ticked.
Am I going about this the wrong way?

Any help on this one would be very muchly appreciated.

Caleb

 

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 01:19

Joined

Jan 20, 2009

Messages

12,852

• Aug 13, 2015

• #2

You should avoid storing calculated data in a table. Every time you need to know if the JobList is complete you should determine if the all the associated JobDetails records have been ticked.

As a rule, no piece of information in a database should be stored in more than one way otherwise it is possible for them to conflict.

 

C

Chill

New member

Local time

Tomorrow, 01:19

Joined

Apr 21, 2015

Messages

3

• Aug 13, 2015

• #3

Galaxiom said:

You should avoid storing calculated data in a table. Every time you need to know if the JobList is complete you should determine if the all the associated JobDetails records have been ticked.

As a rule, no piece of information in a database should be stored in more than one way otherwise it is possible for them to conflict.

Click to expand...

Thanks for the reply Galaxiom.

I imagine a function in the field criteria of the Joblist query would be the go then.
I still unsure how to make this dependent on when each job detail has been ticked however. It's not practical to check manually each time.
Any advice on that?

I know my way around basic VBA etc, but I'm no expert haha.

 

Last edited: Aug 13, 2015

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 01:19

Joined

Jan 20, 2009

Messages

12,852

• Aug 13, 2015

• #4

It can be done in a subquery. A very, very basic example is attached.

 

Attachments

• subquery.zip

  11.8 KB · Views: 122

C

Chill

New member

Local time

Tomorrow, 01:19

Joined

Apr 21, 2015

Messages

3

• Aug 13, 2015

• #5

Exactly what i was looking for, a Select statement like that should do the trick.
Thanks mate, you're a Champion.