Hello:
Newbie here. I have a database with 100s of fields. I need to make a user friendly form to input into the table. I do not want the user to get bogged down scrolling up and down a huge long form.
Is there a way to break up the form into tabs and sub-tabs to the user can enter the field values in a easier and ergonomic way?
Any help will be appreciated.
Thank you.
EDIT:
Hello: Apologies for cross posting. I was not aware that the two forums are connected. And now that post is ‘locked’ after a reprimand. Talk of trial by fire for newbies.
@Ratslinger: Thank you for the suggestion to normalize the data. I certainly plan to break up the table for ease and efficiency. Right now, I am just wrapping my head around the features of OpenOffice Base. Furthermore, I did not want to bog down the original question, which still is open.
I understand Base’s shortcoming for not featuring tabs. Thank you for the clarification.
I am now trying to use a macro which could possibly take the user to another form after entering preliminary information on the first form (just as @LSemmens alluded to). I created buttons after following the fabulous steps outlined by Shane Piper for creating a ‘switchboard’. Upon activation, the second form opens successfully. Unfortunately, it jumps to record #1. Is there a way to prompt the macro to jump to the record being worked on in form #1? I am attaching a copy of my WIP database. Any help will be appreciated.
DB_PatientData.odb
I hope I am clear with my question. Please let me know if you need more clarification. Appreciate all the effort and help you folks are providing.
@Ratslinger: I am attaching a ‘simplified’ version of the .ODB file.DB_PatientData Simplified.odb