My knowledge of access is a bit above beginner however I have only learned what I needed to do for the most part so my knowledge is spotty. Our company is currently running access 2003.
I am currently revamping a production report for a company. Essentially they are moving liquids around and turning them into various definable products, which are all going into separate tanks.
Unfortunately the main idea that was stressed is that the input forms should mimic the current hand printed forms.
With this I run into some issues. Instead of setting up a table with a TO and a FROM column like the current sheet is I have a table that uses negatives to register the FROM a positive to register the TO.
However in order to mimic the sheet that is currently used (a printed off excel) I will have to split the data up. I am unsure of how to tell access to create a new line when they are filling out the form.
The only thing conceptually I can think of is to have 2 sub forms in a window both in datasheet view. However the issue is I need a subset of data to link the two lines of data to show they were one movement.
Is there an easier way than the sub form?
How would I get a "behind the scenes" solution to link the two transactions?
Thanks for your help, if you need any further data let me know.
I am currently revamping a production report for a company. Essentially they are moving liquids around and turning them into various definable products, which are all going into separate tanks.
Unfortunately the main idea that was stressed is that the input forms should mimic the current hand printed forms.
With this I run into some issues. Instead of setting up a table with a TO and a FROM column like the current sheet is I have a table that uses negatives to register the FROM a positive to register the TO.
However in order to mimic the sheet that is currently used (a printed off excel) I will have to split the data up. I am unsure of how to tell access to create a new line when they are filling out the form.
The only thing conceptually I can think of is to have 2 sub forms in a window both in datasheet view. However the issue is I need a subset of data to link the two lines of data to show they were one movement.
Is there an easier way than the sub form?
How would I get a "behind the scenes" solution to link the two transactions?
Thanks for your help, if you need any further data let me know.