>>>Hello, my name is Enrique Duhalt, and I'm new to
>>>Foxpro 3.0.
>>>I don't know how to create a form based on 2 tables
>>>related in a 1 to 1
>>>relationship.
>>>I tried it with a query (like in Access) but the
>>>assistant didn't let me
>>>do it.
>>>Can someone help me?
>>
>>if they are 1-1, the 'assistant' should be able to help...
>>
>>you'd wind up with 'select tablea.*, tableb.* from tablea, tableb where tablea.uniqueid = tableb.uniqueid'
>>
>>if they are 1-1, why would you use two separate tables?
>
>That's because not all the fields are going to be filled and I want to save some disk space.
that won't save disk space -- blank fields will still take the same amount of space...
>
>When I use the form wizard, If I select the other table then It erases the fields that I selected previously from the other table. I don't know what to do next.
i'd recommend combining the two tables. from there, you shouldn't have any problems...