Newbies Inetmaster Posted April 26, 2005 Newbies Posted April 26, 2005 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now