Page 2 of 5
Re: insert multiple lines in a subform.
Posted: Thu Jul 15, 2021 9:27 pm
by kev1n
It would also make it a great deal easier if you could create a minimal example that form/subform together with some dummy data. Then upload the db dump here so I can further assist you.
Re: insert multiple lines in a subform.
Posted: Fri Jul 16, 2021 1:08 pm
by johan
Kev1n
Here's my printscreen
Johan
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 6:24 am
by kev1n
Is new data entered in (1) and then before saving, it should check if (1) does not exist in (2) ?
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 6:49 am
by johan
Kev1n
When entering a new activity, user must enter 1.
Based on this info, 2 must be entered before saving or maybe even better with object RUN.
In this example I entered an activity that takes place weekly between 15 and 22/7.
Employee afterwards still must have the option to make changes in 2?
Johan
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 6:55 am
by kev1n
Can't (2) be generated automatically from (1) when the form is saved? For each day a row is added to (2)
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 7:32 am
by johan
Yes that's the idea for a new form.
I have to check with SQL that the room is available on that moment.
When available fill in the room, if not add date, hours and leave room empty so user can choose An other room
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 7:47 am
by kev1n
Could you also post a screenshot of the db columns of the main form?
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 8:12 am
by johan
Printscreen in attachment.
Johan
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 8:53 am
by kev1n
Could you export the db schema of these two tables to an .sql file? Then I'll try to create a demo on our test platform.
Re: insert multiple lines in a subform.
Posted: Sat Jul 17, 2021 9:55 am
by johan
Kev1n
SQL export of my tables.
We'll use this database for our work in a prison.
So I have to add extra conditions in my select query when a room can be used.
Every room has his max capacity and a room is in a section of the prison. Every section also has it's max capacity. But SQL is not a problem.