问题描述
我希望有人能够帮助我，我很难接近，所以如果我没有正确解释，请原谅我。
我有一个数据表名为ConfirmationTable，其中Main字段称为ParentID。 ParentID是标题为SubID的多个记录的签名ID号。在我的数据表中，我有一个字段，其中有1个ParentID号，包含5或6个SubID记录。我的表如下所示。
ParentID ***** SubID *****客户
12345 ******** 12346 * **** Jeff K
12345 ******** 12347 ***** Jeff K
12345 ******** 12348 * **** Jeff K
12345 ******** 12349 ***** Jeff K
12345 ******** 12350 * **** Jeff K
我正在尝试创建一个表单，以便我可以看到一个ParentID，然后在下面的列表中有一个包含所有相应SubID的子查询ParentID。我已经尝试使用我的表单中的子查询函数将记录链接在一起但是当我去显示记录时，我可以看到ParentID但是SubID记录将仅单独显示给ParentID或者ParentID将组合所有SubID''一起但只显示查看列表中的第一个子ID号。
我试图做一个DISTINCTROW表达式，但无法使其工作。以下是我希望我的表格显示的方式。任何帮助将不胜感激。非常感谢先进。
ParentID ***** SubID ******客户
12345
** *********** 12346 ***** Jeff K
************* 12347 ***** Jeff K
************* 12348 ***** Jeff K
************* 12349 * **** Jeff K
************* 12350 ***** Jeff K
如果我道歉没有正确解释自己，如果这已经发布在网站的错误部分
Hi I hope someone is able to help me, I''m reasonably new to access so please excuse me if I don''t explain myself correctly.
I have a data table called ConfirmationTable where the Main field is called ParentID. The ParentID is the signature ID number for multiple records that are titled SubID. Within my datatable I have fields where there is 1 ParentID number with 5 or 6 SubID records. My table Looks like below.
ParentID*****SubID*****Customer
12345********12346*****Jeff K
12345********12347*****Jeff K
12345********12348*****Jeff K
12345********12349*****Jeff K
12345********12350*****Jeff K
I am trying to create a form so that I can see the one ParentID and then have a subquery with all the corresponding SubID''s in a list below the ParentID. I have tried linking the records together using the subquery function from within my form but when I go to display the records, I can see the ParentID but the SubID records will only appear individually to the ParentID or The ParentID will group all SubID''s together but only show the first SubID number in the viewing list.
I tried to do a DISTINCTROW expression but couldn''t get this to work. Below is how I would like my Form to display. Any Help would be gratefully appreciated. So thanks in advanced.
ParentID*****SubID******Customer
12345
*************12346*****Jeff K
*************12347*****Jeff K
*************12348*****Jeff K
*************12349*****Jeff K
*************12350*****Jeff K
Apologies if I haven''t explained myself correctly and if this has been posted on the wrong section of the site
推荐答案
这篇关于如何使用相应的SubID显示ParentID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！