We are facing some challenges in SharePoint 2003/2007. Here are the
details:

We have created a site it contains two lists. A connection has been
setup between both the lists on the basis of ID, now they behave like
parents and child. One parent record can hold multiple childs, when
user clicks on a parental record, the associated Childs displays below
that record.

Now the problem is:

1. Role Based Access for Fields: We want to control the permissions
for fields (List Columns)
For example: There is a list which contains 10 fields (Text Box, DDL
etc). We have three user groups (SP Admin / Site Admin / Normal User)
and we want that only Admin user can modify all the fields and other
can modify only certain 4 fields. In addition to that the remaining
fields should be visible to this user in Read Only Mode.

2. Role Based View of Fields: We want to hide certain fields on the
basis of User Roles.

Any help to handle this situation will be highly appreciated

Regards,
Pushpendra