>>>I don't know how to create a form based on 2 tables
>>>related in a 1 to 1 relationship.
>>
>>[snipped]
>>
>>>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.
>>
>>Basically, you're building a form into a parent-child table relationship, except that the relationship is one-to-zero-or-one, and not one-to-many.
>>
>>Just create the form normally for your 'parent' table. Then add (drag and drop) the 'child' table in your data environment. If you've set up the table relationships in the database correctly, then the two should automatically 'sync' up.
>>
>>Then just add controls for the required fields. You can use the form builder to do this, or I think you can simply drag and drop fields from the tables in the form's data environment.
>>
>>Is this what you're looking for?
>
>Thanks. I think so. I tried it and looks fine but I can't access the child's table fields. I need to save those fields if they aren't empty.
When adding data to each of the tables in the form you might still need to do something like this:

SELECT TABLE1
APPEND BLANK
SELECT TABLE2
APPEND BLANK

Otherwise the second table's fields will not enable to edit.
HTH,
Greg