[Solved] Input extra information on form?

Creating and using forms

[Solved] Input extra information on form?

Postby shadow350 » Mon Jun 18, 2018 7:49 pm

Hi not sure how to word this but here goes

I have a real estate form for leads works great

I would like to be able to input information on prospective homes for the lead, it can be in any format, but this is the info I need

mls address price. bed/ bath. I was thinking a table on the form ??? I was able to put in a table but can't add any info on it?

this info does not need to be added to the table fields its just for info purposes

does everything on the form have to have a field in the table?
I just want a way to keep track of the homes I would like to show the clients
Last edited by shadow350 on Tue Jun 19, 2018 8:14 pm, edited 1 time in total.
open office 4.1.5
MacBook Air 10.12.6
shadow350
 
Posts: 6
Joined: Mon Jun 18, 2018 7:16 pm

Re: Input extra information on form?

Postby MTP » Mon Jun 18, 2018 10:11 pm

Can you upload a sample file that has had private information removed? When you press "post reply", under the white box there is a tab "Upload attachment" that will let you attach a file for us to look at.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA

Re: Input extra information on form?

Postby shadow350 » Tue Jun 19, 2018 12:39 am

Hi

I have found out that I can add data to the new form table in edit mode only

maybe there a simpler way or did I not check off something?

thank you for your help
Attachments
sample database.odb
(14.9 KiB) Downloaded 48 times
open office 4.1.5
MacBook Air 10.12.6
shadow350
 
Posts: 6
Joined: Mon Jun 18, 2018 7:16 pm

Re: Input extra information on form?

Postby UnklDonald418 » Tue Jun 19, 2018 6:15 pm

Here is an example database based on what you uploaded
sample databaseModified.odb
(35.37 KiB) Downloaded 57 times

It shows two approaches to what I believe you want to accomplish.
I renamed your table to Clients and deleted your form.
For option one I added the table Properties01 and a form Client_Entry01
Client_Entry01 makes use of a MainForm displaying a selected record from Clients, and a SubForm displaying data from Properties01 on a grid. To add a new property to the Prospective Properties list select the Address cell on the first empty row on the table grid and type in data for a new property.

For option two I added table Properties02 and table PropClientLink plus forms PropertyEntry and Client_Entry02.
The form PropertyEntry is used to enter/edit data in table Properties02
Client_Entry02 makes use of a MainForm displaying a selected record from Clients, and a SubForm displaying data from table PropClientLink on a grid. The 1 column on the grid makes use of a ListBox that allows the user to select a property from Properties02 and display the associated data in the boxes to the right of the grid.

The advantage of option two is that the data for a single property can be reused on the list of Prospective Properties for multiple clients. For a single property to appear on the list for more than one client using option one all the data must be re-entered for each client.
The disadvantage to option two is that to enter a new property for a client the user must exit Client_Entry02 and use form PropertyEntry to add the data to table Properties02.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1179
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Input extra information on form? "solved"

Postby shadow350 » Tue Jun 19, 2018 8:18 pm

thank you very much I like option 1 that is exactly what I was trying to do

but I will keep option 2 in mind

thanks again have a great day!
open office 4.1.5
MacBook Air 10.12.6
shadow350
 
Posts: 6
Joined: Mon Jun 18, 2018 7:16 pm


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests