Form displaying multiple records in subtable, when only one exists

[BlueWolverine]

Hello,
MS ACCESS 2003 on XP PRO.

I have a pair of list box? on a form that displays fuel cards. one table
shows what fuel cards are in my inventory and unassigned, and the other shows
what fuel card are currently assigned to that vehicle.

The data has no anomalies in the tables, i.e. there are exactly the right
number of entries for only ONE copy of a fuel card to show up in the
mini-tables.

Howver, when I assign a card to a vehicle, it assigns an extra copy (in the
view mode.) Also, if I unassign the fuel card, it unassigned each ghost as
well, and if I reassign the fuel card, it assigns an additional ghost.

What the hell is it doing?

Here's the SQL for the list box.


SELECT t_FuelCardInventory.FuelCardNo, t_FuelCardInventory.FuelCardProvider,
t_FuelCardInventory.FuelCardSource, t_FuelCardInventory.VIN,
t_FCHistory.Location, t_FCHistory.Comments
FROM t_FuelCardInventory INNER JOIN t_FCHistory ON
(t_FuelCardInventory.FuelCardProvider = t_FCHistory.FCProv) AND
(t_FuelCardInventory.FuelCardNo = t_FCHistory.FCNum)
WHERE (((t_FuelCardInventory.VIN)=[Forms]![f_SerNoResults]![VIN]) AND
((t_FuelCardInventory.Active)=True) AND ((t_FuelCardInventory.Assigned)=True))
ORDER BY t_FuelCardInventory.FuelCardNo;


Please let me know ideas. To the best of my knowledge it's never done this
before. If you need more info please let meknow.

 

[NetworkTrade]

you haven't gotten a reply because your description is unclear - particularly
when you state that in "view" mode there are "ghosts" entries.... this is
an unclear description....

presuming that you say the tables are valid...it maybe is nothing more than
closing an reopening the form in order to refresh the data that is
displaying...

Roll Tide !!