Hi All. Please bear with me as i try to explain this!

I have a report layout that I need to create that will replace a paper form currently in use. The form allows for the inputting of several fields for an invoice. The fields are repeated 4 times on the form to allow for 4 invoices.

I have my database created to where the invoices show up on the recreated form in the database, but the fields only show up for the related invoice records. For instance if there are two invoices, you will see the fields for both, but the form will not show the blank fields for two more invoices.

Is there a way for the form to show the fields for all 4 entries? I am required to recreate the form exactly as it is now.

Thanks for any help!!

The 4 invoices on 1 sheet are 4 of the same invoices? Or 4 different invoices for different customers?

Upload you file...

the sheet allows for 4 different invoices. the sheet is a receiving record of the invoices received for a contract.

i just dont know how to show all 4 invoice parts, if there are not 4 invoices assigned to the receiving record.

i will see if i can upload tomorrow.

thanks!

here is a copy of the form. you can see that the area on the top in unique, then the other invoice area is repeated four times.

the only way i can think of to possibly do this is to count the number of invoice records and go to a different layout based on how many there are. for example if there were two invoice records, it would go to a layout that allowed for two and had two more blank ones hardcoded, etc. maybe?

Why don't you make the entire grid a graphic background, and overlay a transparent portal and fields?

comment - you always give me the best answers! i was trying to deal with it using fancy relationships.

why are the easy solutions the hardest for me to figure out? thanks!

Because you're not lazy enough to look for the easy way out?

My idea too, a portal. You can either have 1 portal with 4 records, but then it's hard to get an exact overlap.

You can also do 4 portals with 1 record each, and let each portal begin where the other stopped, e.g. first, second, third, fourth.