RE: Display fields Limited on Values

The reason that I went this route is that for them to be eligible to be sent
overseas they have tons of different requirements, so i chose to just use
booleans. There names are all just the names of classes that they must
attend. For classes there are 6 seperate classes that they must attend and
its pretty much a did they or did they not attend. And the other tables are
all pretty much the same way e.g. they have 15 different forms that we have
to have on record for them to be sent. All of the records in the different
tables are being joined on a automatically generated ID that is created in
the general info table.

"Duane Hookom" wrote:

If you are using multiple boolean fields then I think your table structure is
wrong. You should not be using "requirements" as field names. Each
person/requirement should create a single record in a related table.

There is lots of good information on normalization on the web.

If you don't understand this, come back with some table, primary fields, and
boolean field names.

--
Duane Hookom
Microsoft Access MVP


"lamartpm" wrote:

Hey,

Sorry, I created the database yesterday. Well the basic layout is a
personal information table with pretty standard fields: Name, address, sex,
D.O.B., etc. The other tables (classes, lab reports, immunizations, and
forms) have boolean fields that indicate whether they have completed certain
requirements. I used a query to join all the tables (all joined on a
personal id (auto-generated)). I also made another query that displays the
names of everyone who has anything not completed. So I want to create a
report so I can say, John Doe, you need to complete this test, form, etc. I
think it would just be an expansion of the latter mentioned query, but I
don't know VBA well. I am pretty good in JAVA, so I know the basic structure
required, but I was hoping for further help.

Thanks,
Paul

"Maurice" wrote:

Well if you want us to think about it give us something to look at (what do
you have, what's the source etc.)

--
Maurice Ausum


"lamartpm" wrote:

I'm pretty fluent in MySQL but I ran into a problem. I have a database that
consists mainly of booleans. It tracks whether people did certain things and
the layout is pretty simple. However, I cannot figure out how to write a
query that will display the person's name and what requirements they still
must meet. I have created a rather lengthy query to display everyone who has
not, but I want to be able to generate a form that will show the people what
they still need to do.

Thanks,
Paul
.

Relevant Pages

  • Re: Update Yes/No Field on form (checkbox)
    ... The boolean field is ... If you want a boolean value for display, ... checkbox control. ...
    (microsoft.public.access.formscoding)
  • RE: Display fields Limited on Values
    ... If you are using multiple boolean fields then I think your table structure is ... person/requirement should create a single record in a related table. ... I also made another query that displays the ... I have created a rather lengthy query to display everyone who has ...
    (microsoft.public.access.queries)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • RE: Just starting to design a form (or is it a query?)
    ... A Form is used to display the data and allow ... A query can be the record source for a form. ... that match an ID in the Assessment table. ... Now, assuming this is the case, what you need is a form with a sub form. ...
    (microsoft.public.access.gettingstarted)
  • Re: database lookup
    ... the query on the subsequent page, and display the "drill down" data. ... The thing with PHP and MySQL is that you need the user to do an action ... I tried to state that I have the database designed and implemented but I ...
    (alt.php)