Hi guys and gals!
I have a dilema that I have been looking at for days now and still can't see the wood for the trees.
I have a databse that monitors vehicle maintenance, servicing schedules and stuff like that.
My problem is we purchase items for the vehicles and I am trying to link the items purchased against the vehicles, the purchased items need to show description, cost, invoice number our purchase number, supplier.
The problem comes when we have just stock items recieved that do not have any relation to the vehicles in the main table. I'm hoping this makes sense. Any help would be appreciated even to clarify my thinking.
I have a dilema that I have been looking at for days now and still can't see the wood for the trees.
I have a databse that monitors vehicle maintenance, servicing schedules and stuff like that.
My problem is we purchase items for the vehicles and I am trying to link the items purchased against the vehicles, the purchased items need to show description, cost, invoice number our purchase number, supplier.
The problem comes when we have just stock items recieved that do not have any relation to the vehicles in the main table. I'm hoping this makes sense. Any help would be appreciated even to clarify my thinking.
