Willir,
It does help. I haven't completely worked it out yet (very long week) but I've created a different database with limited data and tables to simplify it.Thanks, Amy
Well, since you've all helped me so much I think I can chime in on this topic too. I'm not much of a science fiction fan but Orson Scott Card's "Pastwatch" was very good. I've read a couple other books of his.
I am amazed at how fabulous people are on this forum. Yes, this is very helpful. I need to look at the various options. I'm not sure why I've had so much difficulty grasping this. Thanks.
I'm afraid I'm being a bit dense and I might be asking the same questions over again. I created a composite primary key in the:
PARTICIPANT_TABLE
Training_ID
Person_ID
Role_ID
There's a one-to-many relationship between the TRAINING_TABLE (one part) and the PARTICIPANT_TABLE (many part). But...
There's another bit of complication now. I have 3 tables to record trainings and the participants.
PERSON_TABLE
Person_ID (primary key)
Last_Name
First_Name
Etc,
PARTICIPANT_TABLE
Person_ID (primary key)
Training_ID (primary key)
VOLUNTEER_TRAINING
Training_ID (primary key)
Training_Type...
I'm sure the answer is here somewhere but I'm not sure how to search for it.
I have a database of volunteers for a medical reserve corps in the county I work for. The "Person" table is the main table for the database and is organized:
"PERSON TABLE"
Person_ID (primary key)
Last_Name...
I've looked through many of the Max date threads but don't really know SQL too well. I did something that I think works but I'm not sure this is the right way to do this. I have an address table with the fields ID#, Address, and Effective Date. The addresses are updated every month which is the...
I followed the instructions on Martin Green's website(http://www.fontstuff.com/access/acctut10.htm). I created a table with the following fields: Category, Product, Product Number, Publication Date, Supplier (from another table)Notes. The Categories are types of printed materials eg., brochures...
Now I have another problem. Each individual can have multiple records in each of the list boxes (except credential where they have to select one only. Credential are in the person_ID table). So what I had done was create a query with a left join from the person_ID table to the other tables...
It works! Now I don't really need the Last_Name list (not that it did what I wanted it to do anyway). I'll play with this a little with more parameters. Now the next hard part is creating a report.
But I'm still wondering about the DAO ADO thing. Will it be an issue putting this database on...
I need to say first that I don't really know anything about VBA. I know how to cut and paste. I used a tutorial at Martin Green's website on creating dynamic reports: http://www.fontstuff.com/access/acctut19.htm .
I have several tables all linked to the main Person table with a foreign key. I...
I'm working on report. The fields and labels have borders. I can use ctrl and the arrow keys to try to move one right next to another but of course it's always either overlapping or there's some space between them. Is there anyway to tell access to just put one item right next to another without...
Oops, sorry. I don't think I quite understood the question. The registry_person_tbl has about 30 fields but I believe this is the relevent information:
registry_person_table
PERSON_ID
HAVE_OBLIGATION (this refers to military obligation)
MILITARY_DETAIL
registry_obligation_tbl
OBLIGATION_ID...
I used the State's table names. The table with the military question is:
registry_person_tbl.
There are actually 2 fields. The first is a text yes/no called HAVE_OBLIGATION. The second is a text field to describe the obligation MILITARY_DETAIL.
The other table is:
registry_obligation_tbl...
I'm doing a database for our county's Medical Reserve Corps. I have a query made up of 2 tables. The first table has person ID information and some other information. One field asks if the individual has a military obligation in the case of an emergency. A second table has a list of other...
I have split database. Some users may want to do queries on a copy. Is there a way to merge a back end and front end in order to create a query?
I know they can copy the whole thing and relink the tables if necessary but I thought being able to merge it back into one entity might be simpler.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.