Apache OpenOffice Community Forum

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

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.

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

Here is an example database based on what you uploaded 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.

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!