Forum Discussion
Access and joining rows columns and fields
Hello boys and girls! I have some riddle to solve, and I hope I'll find some help...
I have two tables, one personel (like I'd, number, f.name, s.name) and second doc(like I'd, title, related, attachment) now I want every person from table personel to have yes/no checkbox on every doc. Personel number is changing (so copy/paste solve is not applicable) and doc number is growing (add by form by some users). I try to create 3 table whit doc id, person I'd, and yes/no field but I failed, could some one explain me this, how can I achieve sth like form whit all docs as columns(yes/no field) and all personnel as a rows? I want to do this as a form. (Of course then I will apply filters and things like that, reports and all the easy things) sorry for my English😐
Hi Ttsz1
If I understand your request correctly, it would be quite complicated to achieve this and require some significant VBA programming with dynamic field arrays or a comparable solution. Therefore, I'm wondering if Excel could fulfill your request since a spreadsheet has the column/row structure you'll need and adding a person or doc only means adding a row or column. The intersecting cells for persons and docs then contain the yes/no values.
Just a thought.
