Question Automatic fill in field

[zyzor]

Hello,

I have the following issue with my access database.

I have made two tables. Table 1 i use for collecting all the Comic Titles that begin with the letter A. Table 2 i use for writing all the comics that have come with the main title shown in Table 1. In table 2 i gave each title the field where i can choose if i have this title in my possesion. And if all those boxes are checked yes, I would like to see that in Table 1 the box next to the title will fill automaticly, because i have this title complete.

So the question is: How do i do this?

Thanks

Sorry for my bad english!

Here shown in an image:

 

[NickHa]

If I understand you correctly, your Table 1 is used to identify the generic series name and Table 2 is the record of issues you own for the series title? You want the main table to have the flag set when you have collected all issues for the series?

Does Table 2 have a link to Table 1? If so, what is that link? My assumption is that Table 1 has a key value and Table 2 has a field which contains the foreign key for Table 1 - is this correct?

Do you have a form which spans the tables? For example the main form has the comic seies title and contains a subform with the issue titles?

If you can answer these questions and confirm or modify the assumptions, then members of this forum can provid a suitable solution.

It is not considered good practice to have look-up fields between tables, although it works - much better to have a form which controls the table data.

Which version of Access are you using?