Jump to content

Portal problem


MnR

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

Recommended Posts

hi,

I have a problem with a portal showing unwanted records, basically a user can cancel an order, but when cancelled the portal row needs to omited somehow from the portal,

basica structure of db, tbl_customers, tbl_orders and tbl_turkeys.

the reason that i don't want them deleted is due to the business wanting to keep a record of all orders placed. Maybe an export to a file would work? dunno played around with it for ages and still no success. The user cancels the order by pressing a button, this is to stop uncancelling orders and for validation.

any help would be great!

MnR

Link to comment
Share on other sites

You could have a field in the order table called cancelled, and make that field have the value 1 or 0. (Have it auto-enter 0 on record creation)

Now create a global field in the table that relates to the order table, with the value 0. Add a line relating the global field and the "cancelled" field to the portal relationship. This way only records that are not cancelled will show in the portal. If you change the value of the global field to a 1, now only cancelled orders will show. You could set up this field with a checkbox value list so that you can either or both types of orders.

Dana

Link to comment
Share on other sites

Yes i mean only uncancelled orders, and how would you incorperate that into the relationship, note i don't use developer, i am on FM pro 7.

EDIT:

--------

Right got it to work now, adapted the rough idea, placed a global set to 1 in customers and placed a cancelled auto enter 0 in orders, when cancel button pressed it sets the cancelled field in orders to 1 and from changing the relationship (AND cancelled=cancelled) the orders set to 1 are removed.

Thanks for giving me a rough idea of how to solve it!

Link to comment
Share on other sites

This topic is 6983 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.