Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2826

Re: Can't Link Records

Show all headers | View raw

On 2017-04-21 17:58:15 +0000, Charles H. Sampson said:

> Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
> 
>> On 2017-04-19 12:19:57 +0000, Charles H. Sampson said:
>> 
>>> My latest problem: I have a database containing six tables, four of them
>>> related. (The other two are for accumulating data as scripts prepare
>>> reports.) Two related tables have a simple many-to-one relationship.
>>> Let's call the "one side" table A, the "many side" table B. I have a
>>> layout for table A. It has a simple field linking to its related record
>>> in Table B. That field is set up to use values from a drop-down list
>>> with auto-completion.
>>> 
>>> This setup worked for a long time, then I lost the ability to enter data
>>> into that linking field as I create new records for table A. Used to
>>> work; stopped working;
>>> 
>>> I just created a portal in this same layout linking into table B. The
>>> only field in this portal is the linking field. I'm unable to enter data
>>> into that portal's field.
>>> 
>>> In both cases, when in browse mode the linking fields are dimmed and I'm
>>> unable to even place the cursor into the linking fields.
>>> 
>>> This is for FileMaker Pro 8.0v3 on a G5 running 10.5.8.
>>> 
>>> TIA as usual.
>> 
>> Check that the fields is still set to allow user entry in the field
>> definition's Validation options and Auto-enter options. You may have
>> accidentally changed a setting.
> 
> I thought you might have hit on it, HH, but unless I'm misunderstanding
> what you're saying, you didn't. The linking field on the "one" side has
> checked on the Auto-Enter page and the "Only during data entry"
> radio button selected and the "Allow user to override during data entry"
> box checked on the Validation page. Nothing else is selected or checked
> on this page.  (These pages are from the "Options" display for the
> field.) The same is true for the linking field on the "many" side.

Also check that the Relationship defition is still valid, although you 
usually get a "Field Missing" error when that happens.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar

Thread

Can't Link Records csampson@inetworld.net (Charles H. Sampson) - 2017-04-19 05:19 -0700
  Re: Can't Link Records ursus <ursus.kirk@gmail.com> - 2017-04-19 19:25 +0200
    Re: Can't Link Records csampson@inetworld.net (Charles H. Sampson) - 2017-04-21 11:06 -0700
  Re: Can't Link Records Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-04-20 10:01 +1200
    Re: Can't Link Records csampson@inetworld.net (Charles H. Sampson) - 2017-04-21 10:58 -0700
      Re: Can't Link Records Helpful Harry <HelpfulHarry@BusyWorking.com> - 2017-04-22 10:58 +1200

csiph-web