G
Guest
I have a problem that is driving me Nuts. I have a "Stock" Table and (because
my Stock Items are serialised) I tore each item as an individual Record in
the Table. In order not to repeat the same Make and Model information in each
record, I store that information in seperate "Make" and "Model" Tables, only
storing the "MakeID" and "ModelID" in each Stock record so a record in my
"Stock" Table would look something like :- Make=1, Model= 4, SerialNo=1234
etc. In order to retreive the infoemation from the Table, I use a Query that
is linked to all the other Tables to resolve the Numbers Back into a
recognisable name.
The problem is that the query only seems to want to show its own selected
records, even when there is no criteria set in the Query (I would expect that
this situation should show all the records in the table). My use of "Find
First" will not find the Fields that the Query says are not in the Table
(even though they quite definately are)
The problem is very dificult to explain and I have put together a small
database (only 800k) that might help if any one thinks they might have a
solution to the problem
Thanks in advance Ray C
my Stock Items are serialised) I tore each item as an individual Record in
the Table. In order not to repeat the same Make and Model information in each
record, I store that information in seperate "Make" and "Model" Tables, only
storing the "MakeID" and "ModelID" in each Stock record so a record in my
"Stock" Table would look something like :- Make=1, Model= 4, SerialNo=1234
etc. In order to retreive the infoemation from the Table, I use a Query that
is linked to all the other Tables to resolve the Numbers Back into a
recognisable name.
The problem is that the query only seems to want to show its own selected
records, even when there is no criteria set in the Query (I would expect that
this situation should show all the records in the table). My use of "Find
First" will not find the Fields that the Query says are not in the Table
(even though they quite definately are)
The problem is very dificult to explain and I have put together a small
database (only 800k) that might help if any one thinks they might have a
solution to the problem
Thanks in advance Ray C