make multiple distinct entries into one field

  • Thread starter Thread starter wessd
  • Start date Start date
W

wessd

I have to make a form of 1 unique serialized device, that can have up
to 9 unique serialized devices attched to it.

If I use 9 fields, set to indexed no duplicates, it seems to work
except that the SAME unique serial could be posted into
each of the 9 fields and not ever get flagged.....

I think I need some way of putting all or part of the 9 uniques into a
single list.

Ideas ?

WessD
 
WessD,

It certainly sounds like you should have a separate table for the
attached devices. Possibly just a 2 field table, with the ID of the
base device and the id of the attached device. Then you would make a
continuous view form based on this table, and place it onto your
existing form as a subform.

If you need more specific help with this, please post back with more
details including examples.
 
WessD,

It certainly sounds like you should have a separate table for the
attached devices. Possibly just a 2 field table, with the ID of the
base device and the id of the attached device. Then you would make a
continuous view form based on this table, and place it onto your
existing form as a subform.

If you need more specific help with this, please post back with more
details including examples.
Click to expand...


WOW! That was a fast response.

Example I can't provide as in frustration I destroyed my work....

but the gist is this:

RO Serial # (this is the master unique device) indexed

Membrane #1 serial (there are up to 9 unique on the RO, but not
always.) indexed

membrane #2 serial indexed

membrane #3 serial etc

My problem is more clearly I hope,

If you enter a membrane serial in block 1 and another in block 2 on
the first RO entry...on the next RO entry, you can reverse the
membrane entries, and they will be accepted because that is the first
time those serial numbers were used in that order.

I also noticed in a like manner, you can enter the same number
in different blocks AT the same time (IE:on the first RO entry, same
membrane serial # in blocks 1 and 2) and the record will be accepted
without a flag..... These conditions are un acceptable due to the
RO/membranes be medical devices and the serial HAVE to be tracked.

I am thinking, I need just one field to enter ALL the membrane
serials (since the actual order of membranes doesn't matter).

Can I enter serials into a box, press a button for each membrane, then
go on when I finish ?

Thanx
WessD Fly NAVY!!!!!! oops, we beat army again....
 
WessD,

As I mentioned before, you should have a separate table for the
membranes. Just a 2 field table, with the RO Serial and the Membrane
Serial. Then you would make a continuous view form based on this table,
and place it onto your existing form as a subform, with the subform's
Link Child Fields and Link Master Fields properties set to the RO Serial
field. This way, you can enter as many membranes as you like for each
RO, and it will be eqasy to validate uniqueness.
 
Back
Top