Tables and form design

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Fysh (Fysh_at_discussions.microsoft.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 10:03:05 -0700

I am trying something different here and I was hoping someone might have a
suggestion. What I am attempting to do is create a form from a table related
to other tables as follows.

tblCategory tblActivity tblQualType
CATID ACTIVITYID QUALTYPEID
Category Activity Qual

tblSetup
SetupID
Required yes/no
Enabled yes/no
Applicable Value list
CATID
ACTIVITYID
QUALTYPEID

Now that the tables are set up, I am trying to create a form which will show
all the categories, select an activity and a qual type. Next to each
category have a check box for the required field and one for enabled field
and combo box for applicable.

Once the form is filled in have it create or update the table. Create a
query from this table. On another form when an Activity combo box is
selected have it process the query and update the fields on that form. I
know I have to create the code to accomplish this.

I tried using a subform, but that didn't work. I tried a continuous form
that didn't work.

My question is looking at my tables and my first form is this possible, if
so how? If not how would you suggest doing this? Any support would be
appreciated, thanks in advance.

Relevant Pages

  • Re: How get records not in another table?
    ... Small correction to your example. ... The Join was in the wrong direction, what you posted would probably show no records (assuming that ID is a required field) ... John Spencer ... WHERE NOT IN but it took forever to run and I had to cancel the query. ...
    (microsoft.public.access.queries)
  • Re: remove bad rows to another table
    ... >My table holding the records is named tblvisits. ... An Append query followed by a Delete query will do this. ... apply whatever criteria define a "bad ... required field, on separate rows of the query grid (so that OR logic ...
    (microsoft.public.access.formscoding)
  • PERL MYSQL query "IF EXISTS then UPDATE else INSERT"
    ... I want to update my database if the key value is already there then it will ... update the required field else it will insert the new row in the same table. ... Insert query works fine but I am not able to figure out how to achieve this ... someone can give me an example to write such query and execute it from perl ...
    (perl.beginners)
  • Re: Query Results- Incorrect formatting
    ... DesignView of the Query, select the required Field and open the Properties ... There should be a "Format" row in the Properties window for you to ...
    (microsoft.public.access.queries)