A
al
thanks for the reply jeff,
hopefully i can furthur explain :-
an Issue has only One problem part at a time
This problem part could have been supplied by many
suppliers, so need tables to show suppliuer details, part
details and if so, what supplier supplies what part.
Issues attributes include:-
what area the issues in
What proirity an issue is
The owner
Date
Description
Part Number
Part Desc
I want to get the details which will repeat in other
tables to normalise the db, but my normalisation skills
are a little weak!
Thanks for your time, any more help would be great
p.s - what i meant by clocking is that sometimes repeat
issues arise, which means i need a field to count repeats,
maybe something which increments when a button is clicked
or automatically changes when a form is opened.
One more thing....
how do i reference different attributes of tables and show
them in a form to be edited, or add new ones
thankyou!
hopefully i can furthur explain :-
an Issue has only One problem part at a time
This problem part could have been supplied by many
suppliers, so need tables to show suppliuer details, part
details and if so, what supplier supplies what part.
Issues attributes include:-
what area the issues in
What proirity an issue is
The owner
Date
Description
Part Number
Part Desc
I want to get the details which will repeat in other
tables to normalise the db, but my normalisation skills
are a little weak!
Thanks for your time, any more help would be great
p.s - what i meant by clocking is that sometimes repeat
issues arise, which means i need a field to count repeats,
maybe something which increments when a button is clicked
or automatically changes when a form is opened.
One more thing....
how do i reference different attributes of tables and show
them in a form to be edited, or add new ones
thankyou!