Attempt to implement a system to control stock. Orders, likewise users and products are logged on a daily basis. Each order tied to the particular user and parts. Several of thew parts may be ordered under the same Order ID.

Problems:

1.Attempt to log several parts with their respective quantity under the same order ID. I attempt to keep the same order id for the whole lot. Do not want to duplicate and generate id for each of the parts.

2.Want to implement a tracking system, whereas parts id's are checked against records held and inform me whether the same id's were logged on previously. If I want to to continue, by clicking yes, I would create a record.

3. I was considering XML vs SQL and think it is a better idea. Please suggest the ways of searching XML files.

4. I use v.web developer 2005 and when I implement xml using the form, I always see the first record in the file within the form. oNly when I press add, do I see empty text fields. Please, suggest the ways around it.

i would appreciate your comments.

MDM