Access problem

[cli]

Customers accounts
Id name
Monthly subscriber

Films watched online


Film Id
Customer id
Monthly subscriber?

These are 2 tables...in the first one i have thicked all those monthly subscribers...in the 2nd one i want that if ex. customer 1 saw film 2 and is a monthly subscriber, his monthly subscriber check box gets thicked in table 2...how to make pls since i cant find out...thanks

[pbaldy]

I could make a case for not saving the monthly bit in the films watched table, but I can make a case for it as well (status changes over time). In a form, you can use this:

http://www.baldyweb.com/Autofill.htm

Edit: oh, and I deleted your duplicate thread in the chat forum. Welcome to the site!

[cli]

Didnt understand...sorry

[pbaldy]

Didn't understand what?

[cli]

Didn't understand what?

I didnt understand how to solve my problem......

[ArviLaanemets]

tCustomers: CustomerID, ForeName, LastName, ...;
tSubscribtions: SubscriptionID, CustomerID, MonthNo, ... (where MonthNo is eg. in format yyyymm);
tFilms: FilmID, FilmName, ...;
tSeances: SeanceID, FilmID, SubscriptionID, [SeanceDate]. (SeanceDate is optional, in case you need to register cases where the same film is watched several times in month.)