FileMaker Pro: <no values defined> -

-

Therefore IM is working on a hardware inventory and there is a problem with my relationships.

I would like to select one of my "Item_view" layouts and then a brand that matches the unique type (i.e. if I type "smartphones" then I should show all the brands for the smartphone) . The specialty "type" is defined in its table (seen in the picture below), such as brand (models and designations, but I only tried type-brand first - "test db") . / P>

My problem is that if I try to access the "Type" table in the "item_view" layout, then I can select a type but not a related brand (). I created a "pop-up menu" in the "item_brand" field and gave it the value from "brand :: brand", which includes "only: related values ​​starting from" (actually its "type", but for this type German - so do not ignore it)

I think that should work, but I do not. So i need help thx

Here you can see pictures :)

item_view your typ table, 

  item_view :: item_typ = typ :: typ_id

How it looks:

You should be able to create a price list using the brand Type : Enter image details here

Enter image details here

In this way, when you select a particular type, then it typ records can be used to view relationships 

  typ -> Connect - & gt;

To view all related brands of the brand, then you attach that price list as a popup menu or dropdown list in the item_brand area on your item_view layout So that you can choose a related brand.

Enter image details here

It should be noted You are showing all text brand prices, but you should have 'field name' in your item_view table, if you have the ID of the selected brand 'Storage again in the item_view table. Code> type_id and brand_id , because you're actually storing what fields.

You can create a similar value list to use type_id and type_name , so that when you are using a popup menu You can type type :: type but what you are doing in the item_view table is typ :: typ_id value.

I hope this helps!


Comments

Post a Comment

Popular posts from this blog

mysql - How to enter php data into a html multiple select box -

-
I am working on a page that will create a team. I just want to create a selection box which will list all the users of all the users. After that, the user can select more than one friend (i.e. 5) and can send the request to these 5 people to join the team but I am having problems I did this: Select $ sql = "Select i. *, Join * Connect with M * m.id = i.clique_id where adder_id =: id"; $ Stmt = $ db- & gt; Query ($ sql, array ('id' = & gt; $ _SESSION ['id'])); While ($ record = $ stmt-> fetch ()) {$ surname = $ record ['surname']; } and this: & lt; Select multiple = "true" name = "category" well id = "category" name = "category" category = "" & gt; & Lt; Option value = "& lt ;? php echo $ surname ;? & gt;" & Gt; & Lt ;? Php ek $ nickname; ? & Gt; & Lt; / Options & gt; & Lt; / Select & gt; But only a friend's nickname...
Read more

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr...
Read more

c++ - Cassandra datastax cpp driver - avoiding unnecessary copies -

-
I use the following method to create my insert statement for Cassandra (using datastax cpp driver) : ssStmt1 & lt; & Lt; "Insert some table (...) value (....)" string sStatement1 = ssStmt1.str (); Castestring cass1 = cass_string_init (sStatement1.c_str ()); CassStatement * pStmt1 = cass_statement_new (cass1, 0); I have also tried the following: CassString cass1 = cass_string_init ("Enter some table (id, date, c) value (? ,?,?); "); CassStatement * pStmt1 = cass_statement_new (cass1, 3); Cass_statement_bind_uuid (pStmt1, 0, uuidKey); Cass_statement_bind_int64 (PSTMT1, 1, timestamp); Cass_statement_bind_string (pStmt1, 2, sSomething); The first pattern works with mixed keys, the second is not. The key has a timestamp and a UUID. Timestamp is one of two errors in the field (based on the used bond statement). If bound in this way: cass_statement_bind_int64_by_name (pStmt1, "date", timestamp); I get the following error: Inva...
Read more