Lookup Tables and checkboxes

SueAccess

Registered User.
Local time
Today, 04:38
Joined
Jan 22, 2005
Messages
26
Can someone tell me if what I'm trying to do can be done? I'm trying to do something that would be very easy to do on a web page but not so easy to do in Access Forms (or maybe I'm not too bright).

I have a main table called IPP-GOL Database containing web site information and a lookup table called SPP Life Cycle LU and finally a table to store all Life Cycles applicable to the web site.

My main form called Product Profiles contains a subform called Life Cycle. When certain Life Cycles are checked, I would like the table SPP Life Cycle to be updated (either new records or delete unchecked records).

Can this be done without using any event programming?

I've enclosed my sample database.

If what I'm trying to do can't be done could someone please let me know.

Many thanks.

Sue
 

Attachments

Users who are viewing this thread

Back
Top Bottom