Please help!

[optimus_1]

Morning all.

Hopefully this is pretty straight forward.

When entering information in a form i want data to automatically appear when i enter details in a certain field. i.e

Table_1
Name Age Height etc
J.Bloggs 30 6'5"

Form_1

NameWhen selecting this field from a combo box)
Age: (This field needs to automatically appear from the table data)

Time_Mon: 7
Time_Tues: 7
Time_Wed: 7
Time_Thurs: 7
Time_Fri: 7 etc..

Hope that makes some sense to somebody, if not then please ask for clarity.

Thanks

 

[RuralGuy]

If you have the two tables joined on the PersonID as your RecordSource for the form it *will* happen.

 

[optimus_1]

Im sorry im not that experienced with Access, im not 100% sure what you mean.

I have attached a copy of a database which requires what i need.

I require the 'clock no' to appear on the 'HAVS' form when the operative name is entered

Cheers

 

[RuralGuy]

See if this does what you wanted. I deleted some fields from the tblMain table because they were not necessary and would violate normalization rules. You really need to study up on normalization. Think narrow and tall (lots of records and few fields) instead on short and wide. Repeating field names is a dead give away to normalization problems.

 

[optimus_1]

Thankyou that is exactly what i was after.

May i ask how you went about doing it so i know for future reference and can look into doing such things for myself.

Thanks again

 

[RuralGuy]

Your form is now based on a query that joins the two tables. The ComboBox now supplies the OperatorID instead of the name and lets the query join do the rest.

 

[optimus_1]

Thank you for your help.

I have got to expand this database to inputting time information daily with you suggesting thinking high and narrow rather than short and wide Maybe i could ask for your opinion on how it is best to achieve this?.

I basically need to amend the 'HAVS input' form to capture time entry daily which i can do. But where i might struggle is if a person uses more than one item of equipment during the same week?

Thankyou for your previous help, it help me no end

 

[RuralGuy]

Normalization is a subject that is beyond the scope of simply posting in a thread. There are pleanty of threads here that discuss the subject and Google will find more for you. Here's some other links to read.
Fundamentals of Relational Database Design
http://wiki.ittoolbox.com/index.php/Normalization
http://www.phlonx.com/resources/nf3/