By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

selecting data only once to avoid duplicating

P: n/a
How can I get a adtabase to recognise that a piece of data has already
been "used" in connection with another piece of data in another field.
My database is focussing on timetabling and I cannot have a person in
2 places at once.
Thankyou

Feb 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Feb 22, 1:55 pm, "wannabeateacher" <s...@downtothewoods.me.uk>
wrote:
How can I get a adtabase to recognise that a piece of data has already
been "used" in connection with another piece of data in another field.
My database is focussing on timetabling and I cannot have a person in
2 places at once.
Thankyou

There are many ways, but your explanation is too vague to provide
useful advice.
When does the check need to be done, in a form, query, table - on
save, open, change of record?

Feb 22 '07 #2

P: n/a
On 22 Feb, 19:30, "storrboy" <storr...@sympatico.cawrote:
On Feb 22, 1:55 pm, "wannabeateacher" <s...@downtothewoods.me.uk>
wrote:
How can I get a adtabase to recognise that a piece of data has already
been "used" in connection with another piece of data in another field.
My database is focussing on timetabling and I cannot have a person in
2 places at once.
Thankyou

There are many ways, but your explanation is too vague to provide
useful advice.
When does the check need to be done, in a form, query, table - on
save, open, change of record?
It would be at change of record I think because when a person is
deployed for one students lesson (my database is in a school), the
timetabler will go on to deploy for the next lesson and therefore that
person cannot be used for any other student during that time slot.

Feb 22 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.