Ask Your Question
0

Show multiple fields from table in subform

asked 2019-07-02 13:14:02 +0200

Kavita gravatar image

updated 2019-07-03 17:48:33 +0200

Hi, My tables are as follows 1. Item - ItemID, Code, Description, some more fields 2. Order - OrderID, some more fields 3. OrderDetail - OrderDetailID, OrderID, ItemID, some more fields.

I am creating data entry form for Order. I need to enter multiple items against a single order. I have created master form and sub form for order and order detail. While selecting item in order detail i am able to create it list box and display item code and linked with item id. that all is working fine.

my question is, i want to display more field of items (in addition to code) in sub form. I want user to see multiple fields say code, description, size from item table and id should be saved in order detail (like its happening right now).

Please help.

See image below for more detail image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-02 18:04:31 +0200

Ratslinger gravatar image

Hello,

It appears your main question is mis-leading. Details of the question do not seem to relate to a report at all - just a form.

So based on that it looks like you have (internally) the form and subform working properly which gives you the answer. Select a record in the form and the linked subform presents related records.

But Base forms are not limited to form/subform. You can go deeper - subsubform, subsubsubform etc. So the solution is to add a subsubform for Item table with the link to the subform (listbox) being the ItemID.

edit flag offensive delete link more

Comments

Hi, Thank you for your answer but my requirement is to show the item code, description and 1 more attribute on same row in order detail form and for all items in the order detail. once a new item is added/updated in order detail, it should populate all 3 fields on change of one field.

Kavita gravatar imageKavita ( 2019-07-03 17:45:11 +0200 )edit

@Kavita,

Display within an existing grid line requires macro code (this is specific to you Base file) and saving this data is actually duplicating the data within the DB - certainly not recommended. Have done something similar in the past. See my answer in this post -> How to use user selected value from combobox1 in combobox2 'SELECT' statement.. It is understood you are not using a list box as in the sample but the concept is the same.

Ratslinger gravatar imageRatslinger ( 2019-07-03 18:17:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-02 13:14:02 +0200

Seen: 24 times

Last updated: Jul 03