Goods Inward Design Help.

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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
 
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
 
Back
Top