Repeating group search terms

Need help
1

I have two tables:

1st table called BAGS that has two fields:

BagName and IsBagPrinted with entries:

  1. Blue Bag - Yes
  2. Red Bag - No
  3. Yellow Bag - Yes

2nd Table is called ORDER-TABLE that only has the name of the bags so one field only
BagName

with entries:

Blue Bag
Blue Bag
Yellow Bag
Red Bag
Yellow Bag

So I want to create a repeating group from the table ORDER_TABLE that shows only bags that are printed.

Is there a way of doing that please?

2

Well, unless you have more fields in the ORDER-TABLE the two tables are basically the same.

the first repeating group / table would be:

do search for BAGS.

it will show you all bags with all printed status.

The second table / repeating group you can make has a data source:

do search for BAGS but it has a constraint:
isBagPrinted = yes

it will then only list the printed bags.

If you need an order table / data type because you have a lot more fields that you need in that particular table you can create a field in ORDER_TABLE called BAGS. This is not a text field but a field of type BAGS.

This way you link BAGS to ORDER-TABLE.

But I do not think this will get you where you need to go. I would stick to as little data types as you can and it seems you can manage with just the BAGS table looking at your example.

3

Both tables have around 12 fields each! I’ve just simplified this here.

The second table ORDER-TABLE has order number, customer name, customer address etc, so I need to create a repeating group that shows only the customer orders that have printed bags on order so that I can pass it to the right person in the factory.

How do I do that?

4

You can try a constraint in the ORDER_TABLE (but you need a field of BAGS that is of type BAGS)

BAG = do search for BAGS with constraint isBagPrinted = yes

5

However, it sounds like an order can have multiple BAGS on it.

In that case you need to ahve a field of BAGS that is a list on the ORDER_TABLE.

then the constraint will be:

search for ORDERS where BAGS contains do search for BAGS where Printed = yes

6

I simplify things and if I have an order with two bags or more I create a new record with same order number, so one record per bag but two records can have the same order reference, to keep things simple. Not Ideal but when I get better with bubble will upgrade!..sorry this is me too( various2 )

7

This topic was automatically closed after 70 days. New replies are no longer allowed.