I have related fields that pull data from a record if it matches the
serial number from the other record.

What i want to be able to do is if there is no number for it to get
the data from, i want to be able to type data into those fields but i
cant seem to be able to type data into the related fields.

Regards,

Michael

Is the relationship setup to allow creation of related records?
If not goto define relationships > edit > then select the checkbox allow 
creation of related records.

Michael Myett

inzane wrote:
> I have related fields that pull data from a record if it matches the
> serial number from the other record.
> 
> What i want to be able to do is if there is no number for it to get
> the data from, i want to be able to type data into those fields but i
> cant seem to be able to type data into the related fields.
> 
> Regards,
> 
> Michael

inzane wrote:
> 
> I have related fields that pull data from a record if it matches the
> serial number from the other record.
> 
> What i want to be able to do is if there is no number for it to get
> the data from, i want to be able to type data into those fields but i
> cant seem to be able to type data into the related fields.
> 
> Regards,
> 
> Michael

In the definition of thhe relationship, check Allow Creation of Related Records.
-- 
Return address intentionally altered to avoid spam.

This method does allow me to type data in these fields, but it creates
a new record in the other file with this information. I dont want this
to happen. If the Match field matches i want it to get the data from
the source, otherwise i just want to type data into the fields in the
destination file, but not change the source file in any way.

Can you help?

Regards,
Michael


Michael Myett <michael.myett@verizon.net> wrote in message news:<0JLdb.12896$541.6561@nwrdny02.gnilink.net>...
> Is the relationship setup to allow creation of related records?
> If not goto define relationships > edit > then select the checkbox allow 
> creation of related records.
> 
> Michael Myett
> 
> inzane wrote:
> > I have related fields that pull data from a record if it matches the
> > serial number from the other record.
> > 
> > What i want to be able to do is if there is no number for it to get
> > the data from, i want to be able to type data into those fields but i
> > cant seem to be able to type data into the related fields.
> > 
> > Regards,
> > 
> > Michael

Instead of placing fields from the related record on your layout in the 
parent file to show info from a relationship, create these same fields 
in the parent file and base their value on a lookup.

Set the lookup properties in define fields > options > check looked-up 
value > specify, then choose the relationship on which to base the 
lookup, choose the field to use and finally under the options for what 
to do when there is no match, select the last option and leave field blank.

In the users manual for version 5 and up there is a pretty good 
explanation of lookups vs. relational data, that can provide additional 
insight.

Michael Myett

inzane wrote:
> This method does allow me to type data in these fields, but it creates
> a new record in the other file with this information. I dont want this
> to happen. If the Match field matches i want it to get the data from
> the source, otherwise i just want to type data into the fields in the
> destination file, but not change the source file in any way.
> 
> Can you help?
> 
> Regards,
> Michael
> 
> 
> Michael Myett <michael.myett@verizon.net> wrote in message news:<0JLdb.12896$541.6561@nwrdny02.gnilink.net>...
> 
>>Is the relationship setup to allow creation of related records?
>>If not goto define relationships > edit > then select the checkbox allow 
>>creation of related records.
>>
>>Michael Myett
>>
>>inzane wrote:
>>
>>>I have related fields that pull data from a record if it matches the
>>>serial number from the other record.
>>>
>>>What i want to be able to do is if there is no number for it to get
>>>the data from, i want to be able to type data into those fields but i
>>>cant seem to be able to type data into the related fields.
>>>
>>>Regards,
>>>
>>>Michael

inzane wrote:
> 
> I have related fields that pull data from a record if it matches the
> serial number from the other record.
> 
> What i want to be able to do is if there is no number for it to get
> the data from, i want to be able to type data into those fields but i
> cant seem to be able to type data into the related fields.
> 
> Regards,
> 
> Michael

After reading your original message again and the responses, I must say
it is not clear to me what you want to do.

Let me try this and see if I understand.

You have a Master file and a related file. You have a relationship based
on a key field that contains a serial number.

If there is a related record that matches the key field, you want to be
able to display the data from that related record in a layout of the
master file.

If there is not a related record, you want to be able to enter data in
the master file, but not affect the related file. In other words, you do
not want to create a new record in the related file to contain the new
data, you just want it entered into the master file.

If this is what you are trying to do, then you need to create fields in
the master file to hold the information. Define these fields to look up
data from the related file. If there is no data from a related file,
simply type the information into the appropriate fields of the master file.

Bill


-- 
Return address intentionally altered to avoid spam.

Thanks very much bill this method seems to be working.

Regards,
Michael.