Lookup fields

[inzane]

I have a field in the client database called userid, when i put a
number in this field it checks the internet database for that number.
If that number exists it pulls data from selected fields on the
Internet database and puts it into fields in the client database. When
i remove the userid all the details stay in the fields in the client
database. Is there a way to make these dissapear when the userid is
removed??

Regards,

Michael

[Michael Myett]

You can do a Re-Lookup using the now empty lookup field or base the
values on a relationship instead of a lookup.

Michael Myett

inzane wrote:

> I have a field in the client database called userid, when i put a
> number in this field it checks the internet database for that number.
> If that number exists it pulls data from selected fields on the
> Internet database and puts it into fields in the client database. When
> i remove the userid all the details stay in the fields in the client
> database. Is there a way to make these dissapear when the userid is
> removed??
>
> Regards,
>
> Michael

[inzane]

Michael Myett <michael.myett@verizon.net> wrote in message news:<nT1ob.32184$4O1.28828@nwrdny01.gnilink.net>. ..

> You can do a Re-Lookup using the now empty lookup field or base the
> values on a relationship instead of a lookup.
>
> Michael Myett
>
> inzane wrote:

> > I have a field in the client database called userid, when i put a
> > number in this field it checks the internet database for that number.
> > If that number exists it pulls data from selected fields on the
> > Internet database and puts it into fields in the client database. When
> > i remove the userid all the details stay in the fields in the client
> > database. Is there a way to make these dissapear when the userid is
> > removed??
> >
> > Regards,
> >
> > Michael

Can you please explain how to do the re-lookup im new to the filemaker scene.

Regards,

Michael

[Michael Myett]

In your primary file, isolate the record in question, then go to the
field your lookup is based on and select Relookup Contents from the
Records menu. If you have removed the userId this should clear the
fields.You could script this using,

Omit Record
Show Omitted
Relookup Contents [field lookup is based on] perform without dialog

Michael Myett

inzane wrote:

> Michael Myett <michael.myett@verizon.net> wrote in message news:<nT1ob.32184$4O1.28828@nwrdny01.gnilink.net>. ..
>

>>You can do a Re-Lookup using the now empty lookup field or base the
>>values on a relationship instead of a lookup.
>>
>>Michael Myett
>>
>>inzane wrote:
>>

>>>I have a field in the client database called userid, when i put a
>>>number in this field it checks the internet database for that number.
>>>If that number exists it pulls data from selected fields on the
>>>Internet database and puts it into fields in the client database. When
>>>i remove the userid all the details stay in the fields in the client
>>>database. Is there a way to make these dissapear when the userid is
>>>removed??
>>>
>>>Regards,
>>>
>>>Michael

>
>
>
> Can you please explain how to do the re-lookup im new to the filemaker scene.
>
> Regards,
>
> Michael