Duplicating records in a form-based on check boxes (1 Viewer)

sh5mg

New member
Local time
Today, 13:01
Joined
Nov 21, 2019
Messages
5
Hi!
I am a bit new to this so I was hoping for some help.

I am building 2 linked forms to fill in data in 2 tables (linked via an ID #).

Basically the first table contains general info to an order:
purchase date, invoice id, customer etc

the second table has the actual invoice info: (the bit i'm worried about)
ship date, order number, etc, except it also has to include the item number.

since all the data in the form 2 is the same for every column EXCEPT item number, is there any way to go along creating the form as if it is one row, and then at the end select (via check boxes or drop downs to select in a table) a pre-selected list of items and have this generate multiple rows in table 2?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:01
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF! Can you post a screenshot of what you mean? I want to make sure you're not really duplicating data between tables. Thanks.
 

sh5mg

New member
Local time
Today, 13:01
Joined
Nov 21, 2019
Messages
5
Hi,

Sorry i can't directly as its for work and the data is proprietary.

I have the forms built out sans the item, so i know it is not duplicating.

However it goes something like this

Form 1:
has boxes to enter info for table 1 info described as above.
then i have a "button" that saves the info entered, closes the current form and opens the next form.

Form 2
has boxes to enter all the data for table 2 (as described above)
has a button that also saves and closes.

the only thing not accounted for is the "item" box. i can currently enter in 1 and have the form generate 1 row in each table, but I cannot get to allow me to put multiple "items" at once (and therefore create multiple rows at once, with just the items being different, and the number of items determining the number of rows)
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:01
Joined
Oct 29, 2018
Messages
21,358
Hi. Thanks for trying to explain. If data is proprietary, are you able to mask it or use dummy data instead for your screenshots? What are these "rows" you're trying to auto-create?
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:01
Joined
Sep 21, 2011
Messages
14,044
You should not be duplicating the data for the invoice?
I would have thought you would have

Code:
Customer
    Invoice
         Invoice Details (Line Items)

So each Line Item would have different data in it.?
 

Users who are viewing this thread

Top Bottom