Re: Query questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 15:27:49 -0700

On Tue, 02 Mar 2004 20:03:51 GMT, "Pete Davis" <pdavis68@hotmail.com>
wrote:

>I have an app for a real estate company. There are 3 main forms:
>
>ForSale
>ForRent
>PropertyDetails.
>
>Both the ForSale and ForRent properties are each associated with a
>PropertyDetails record, so the PropertyDetails form is a subform for both
>the ForSale and ForRent form.
>
>My client wants a button that will create a copy of all the data for the
>current record, minus the keys.
>
>So, let's assume we've got the ForSale form up. The first thing I need to do
>is create a new copy of the property details record.

I'm really queasy about this. I wonder if you have the relationships
backwards! It's still the same piece of property; storing all of its
information redundantly in a second table seems unwise.

Might it not make more sense to have *one* property record? It could
be linked both to the Sales and Rentals tables, could it not?

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Quantcast