Jump to content
  • 0

Report datapage - allow multiple users to claim a record



Perhaps already asked/answered - but couldn't find the answer. 

I have a report data page that returns data based on criteria a user can dictate. Once the records are returned - I'd like users to be able to indicate that they own the product returned in the record and be able to state where they have the item located. For example: user could search for items tagged in the system as "ingredients". If two items return from the Inventory table and are "flour" and "crisco" - I want the user to be able to check a box that they own crisco - expose a drop down text box allowing them to enter the location of the crisco: in the pantry. 

Ultimately this would allow the user to be able to see all items in the inventory table and have the results indicate they own items in the inventory table. Or they could see just the items they own. 

right now I have a table called inventory, users, owneditems with a relationship between the three tables. I believe the only way to allow a user to claim an item would  be to have an item detail screen with the details on the left side of the page and a submission form on the right side of the page where the ItemNO is passed from the details report to the owneditems table. That would allow the user to enter that they own the item and put in a location where it's at.

But - if they go back and search for all items - I can't get the system to show me that I already own some items in the results page. I have to either see all items or see what I own. 

Thanks in advance - 




Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...