Goods Inward Design Help.

[Chris]

Hi all,

I have a problem that has been taxing me for ages.
I want to create a goods in system for purchase orders,
rejections and free issue items.
Any item that comes into the company must be booked and
assigned a number (grn). This is easy enough for purchase
orders but I can't seem to combine this with rejections.
Any ideas would be greatly appreciated.

Chris

 

[Seth Schwarm]

Chris:

I don't quite understand your application lingo. Can you
put in more general terms?

I am assuming you are wanting several different types of
physical objects to all be tracked in one table and thus
generating a continuous numbering system.

This can be done by creating a field where you allow a
name for the object you are checking in. The values it
would store are Purchase Order, Rejection and Free
Issue. I would make it a combo box on your form.

Are we heading in the right direction?

Seth

 

[Chris]

Seth,

Thanks for comming back to me.

Yes, you are on the right track. Anything that comes in
needs to be booked in and receive a unique number (the grn
number). The form that I have in mind for booking in
these items needs to show the details from the purchase
order or reject note so that the person who is booking in
the items knows that what they are getting is correct.
Purchase orders are simple enough as I can create a
relationship between Purchase order Details and Goods
inward. However rejection notes need the 'grn number' and
I can't works out how to relate this table back to goods
in.

I'm currently working on a union query to see if that
would be a better solution, but any other ideas would be
greatly received.

Many thanks
Chris