Excel Database

[zezo2021]

Friends

Client asked from me to create database in Excel and refuse to use access

my question is:
He wants to use Excel forms

How can make one to many relations on Excel forms? forms and subforms in Access

I appreciate if you have an example

 

[CJ_London]

How can make one to many relations on Excel forms?

So far as I know you can't since excel does not support the strong datatyping etc or mechanisms required for relationships

forms and subforms in Access

if you mean like the linkchild/master properties of subforms, I don't think forms2 used by excel allow the creation of subforms - but if they do, it will only be possible if those properties exist as well. Seem to recall they use a datagrid type control

best you can do is have some code to autopopulate the FK in the child table or provide a combo or similar for the user to select one

Excel and Access are two different beasts, the way they work are at opposite ends of the data processing world. As we say to people coming from the excel world 'forget about applying excel thinking to access', the same applies when going in the opposite direction.