Copy values to a form

I have a form with information about a propertyField names: “address”, “city”, and “directions”

I have another form for tracking inspections on the properties (one to many relationship).

When I create an inspection, I select the address with view lookup.

We print out these forms and hand them to inspectors.

How can populate a field on the inspection form to automatically include other information from the property form… like: direction, & city

I tried to use @dblookup with out much success.

I’m still pretty new to this

Jim Lamb

Real Estate Depot

Subject: Copy values to a form

Make ‘Inspection’ a form of type ‘Response’ (you do this in the form properties), then set the default values of the fields on the form to the names of the fields on the ‘Property’ form that you want to inherit:

(Form) Property, (Field) Address

(Form) Inspection, (Field) CurrentAddress - Default Value: Address

Paul.

Subject: RE: Copy values to a form

Making the Inspection form a response form isn’t necessary, although probably desired. You left out, however, the only necessary part: enabling inheritance on the Inspection form:

Subject: RE: Copy values to a form

Ouch. I can’t believe I left that part out.

:frowning:

Subject: RE: Copy values to a form

I hear ya. I figure any day that I can remember my house keys when I leave for work is a good day. I wish I had more good days!