Question best way to organise a "Weight tracking" database for multiple users???

[Burnsie]

Morning all.

I’ve been tackling this for a few days now and keep hitting a brick wall.

I’ve tried learning MS Access using the video tutorials on the MS website

What I’m wanting to do is create a database where you can record the body weight (on more than one date per user) of multiple participants.

I know I need a table for personal details (name, age, sex etc).

I know I need a table for weight measurements.

I know I need to build a relationship between the two tables (in this case I use a participant ID and link them between the tables).

Its here where I stop....

What I really want is;

1- to open the database and be greeted with a list of participant names.
1a- (as an admin user I would need access to a table/form that allows me to add/edit participants)
2-when I click on a name I want it to simply display a form/table with each record showing - part ID, name, Date, Weight. This form should allow new information to be inputted.

Its with the whole query bit that I start getting confused

Is this an okay way of doing it? Is there a better/easier way?

Many, many thanks

B

 

[neileg]

You can set the start up options of your database to show a specific form.

I think you need a form/subform setup. The form should show the participant details and the subform will show the related weight details. Access will synchronise the two sets of data. When you add a new weight record, Access will automatically assign the partID to this record.

 

[Burnsie]

geeeeezzzzzzzzzzzzzzzzz

where were in last week?

you

absolute

legend

next question.... I’ve created the subform from one of my tables. However, when i enter data i want Access to automatically update the source table. I thought i would do this automatically, but its not.

any suggestions?

thanking you