Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Portal help - cant edit / add rows


This topic is 7153 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I'm a newbie to FM development and am hung up on what to do here.

I have a few tables (please see attached PDF for my relationships graph) that are related that I want to reference in a portal.

I want to associate Items to an Auction. The auctions table is related to an AuctionItems table. Items are related via the AuctionItems table. On a layout, I have details of an auction, and want to be able to add predefined items (from the items table) via a portal. I would like the fields Item Number and Item Desc to show in the portal.

I **should** have my portal and relationships setup okay, but I am not for sure.

I'm having a few issues:

1. If the fields in the portal are left as Edit Boxes, I can click in them, but not type any data in - it seems it is not accepting keyboard input.

2. I would prefer to use a Value List of all the Items in the Items Table to make data entry easier. I can successfully setup one of the fields to be a Value list popup or menu, but choosing an items does not populate the fields.

3. I'm a newbie, so I am no script expert. I thought of opening a new window to allow the user to see a list of all the items. If I use the command, Set Field[AuctionItems::Auction; Auctions::uid), an entry is created in the AuctionsItems table, which will show an extra blank entry in my portal. What I could not figure out in this approach is how to populate the same row filling in the AuctionItems::Item field with Items::uid - a Set Field in the same script with a button 'Resume Script' did not seem to work between windows, but this may be by Filemaker design, and I just didn't know that.

Thanks for the help - I'm really stuck on this one....

Wayne P.

PaymentPortal.pdf

This topic is 7153 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.